By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
454,968 Members | 1,215 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 454,968 IT Pros & Developers. It's quick & easy.

Entering numeric data does funny things

100+
P: 462
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.
May 4 '09 #1
Share this Question
Share on Google+
8 Replies


Expert 100+
P: 1,287
You must have code for another event like KeyPressed, because AfterUpdate isn't normally triggered by simply typing in a field.
May 4 '09 #2

ADezii
Expert 5K+
P: 8,679
@CD Tom
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.
May 4 '09 #3

missinglinq
Expert 2.5K+
P: 3,532
Or gremlins! Don't forget the Access gremlins!

;0)>
May 4 '09 #4

100+
P: 462
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.
May 4 '09 #5

ADezii
Expert 5K+
P: 8,679
@CD Tom
Well, what was wrong - please share.
May 4 '09 #6

100+
P: 462
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.
May 4 '09 #7

Denburt
Expert 100+
P: 1,356
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...)
May 5 '09 #8

NeoPa
Expert Mod 15k+
P: 31,709
@Denburt
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.
Expand|Select|Wrap|Line Numbers
  1. Nice call                       ChipR
or, another common one is :
Expand|Select|Wrap|Line Numbers
  1. Nice call ChipR                      :)
Both display sensibly.
May 7 '09 #9

Post your reply

Sign in to post your reply or Sign up for a free account.