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

Input mask problem

P: 1
Hi, I am a new guy in town.
Could anyone plesae help. I could not understand why.
The forms I design using MS Access 2000 has some simple input mask like 00:00;0;_ . It work in some computers but not in some. If it does not work, the cursor just stucked in the first no and do not advance, just keep on changing the first character!
All my office computers use Windows 2000 and Office 2000. Configuration are quite similar.
Thanks in Advance.
Oct 6 '07 #1
Share this Question
Share on Google+
3 Replies

Expert Mod 15k+
P: 31,489
You have (accidentally) posted this question in the Access Articles section. This is NOT an article.
I'm moving this to the main Access questions forum.

Oct 6 '07 #2

Expert 2.5K+
P: 3,072
Odd problem and often hard to find as it does work on some computers and fail on others.
In cases like this my first check is to see or the Regional settings (Use the Start / Settings / Configuration to get to the application) are identical.
Especially the listseparator and the decimal separator are to be checked to be exactly the same on the "OK" machines and the "erroneous" machines.

Another option is to open some VBA code (e.g. by pressing [CTRL+G]) and select Tools/References.
Each libraryname starting with "MISSING" must be unchecked and (e.g. microsoft DAO version x.xx) replaced when necessary.

As access doesn't cleanup added libraries, often unnecessary refenreces are present.
Just delete as many as possible without getting an error executing "Debug/compile all modules"

Oct 6 '07 #3

Expert 2.5K+
P: 3,532
I don't think the cursor is getting stuck on the first number, I think it's getting stuck on the last number! When the cursor is on the last character in a Masked field and you keep on typing, normal behavior is that it doesn't move forward and the final character is repeatedly replaced! If, on the offending machines, you go to Tools - Options - Keyboard, I think you'll see that the Behavior Entering Field is set to Go to End of Field, which is what it's doing, becoming stuck and replacing the character!

You could change this to Go to Start of Field, but you may tick off the "owners" of these machines, who like it the way it is, and you'll still have a problem! If the users mouse into the field instead of tabbing in, the insertion point will be wherever they clicked on the field, not necessarily at the beginning!

Go to the tutorial on this site titled Input Masks and pay special attention to the second post. It gives two code snippets that will cure these problems!

Welcome to TheScripts!

Linq ;0)>
Oct 6 '07 #4

Post your reply

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