Entering numeric data does funny things

[CD Tom]

I'm lost, I have a form with fields called time1 time2 that are set to standard format Auto decimal with nothing out of the ordinary but here's what's happening I can only enter 1 digit into the field and then it jumps to the next. I have an after update set to check the time1 entered and of course after I enter the first digit it jumps to the after update code. I've restarted Access but still the same thing happens, I have a different database the I do the same thing in and that one works fine. Does anybody have any clues as to what could be happening.

[ChipR]

You must have code for another event like KeyPressed, because AfterUpdate isn't normally triggered by simply typing in a field.

[ADezii]

I'm lost, I have a form with fields called time1 time2 that are set to standard format Auto decimal with nothing out of the ordinary but here's what's happening I can only enter 1 digit into the field and then it jumps to the next. I have an after update set to check the time1 entered and of course after I enter the first digit it jumps to the after update code. I've restarted Access but still the same thing happens, I have a different database the I do the same thing in and that one works fine. Does anybody have any clues as to what could be happening.

Either ChipR is correct, or the Control Source for the Field is {TEXT 1}, an Input Mask allowing for a Single Character exists, and Auto Tab is set to True. In this 'very unlikely' scenario, the AfterUpdate() Event would be triggered after only a single Character is entered into the Field. I do not see any other possibilities at this time.

[missinglinq]

Or gremlins! Don't forget the Access gremlins!

;0)>

[CD Tom]

I figured it out, it was a silly error on my part, it seems like you can work on things for hours, then it hits you what's wrong. Thanks for all the replys.

[ADezii]

I figured it out, it was a silly error on my part, it seems like you can work on things for hours, then it hits you what's wrong. Thanks for all the replys.

Well, what was wrong - please share.

[CD Tom]

There was a Key down function where I was checking some data at the end of it was a me.refresh, this caused every key down to refresh and that caused the problem. I check the program that was working and that's what I found different, so when I remove the me.refresh everything is working fine. Thanks again for all suggestions.

[Denburt]

There was a Key down function where I was checking some data at the end of it was a me.refresh, this caused every key down to refresh and that caused the problem. I check the program that was working and that's what I found different, so when I remove the me.refresh everything is working fine. Thanks again for all suggestions.

Nice call ChipR .......... (a little extra for the short message call...)

[NeoPa]

Nice call ChipR .......... (a little extra for the short message call...)

Endorsed :)

PS. Den, you probably weren't around when the workaround was published for that. As any multiple spaces are always resolved to a single space (except in the CODE tags of course, but we won't go there now) you can simply reach the minimum with extra spaces embedded.
EG.

Nice call                       ChipR

or, another common one is :

Nice call ChipR                      :)

Both display sensibly.