Roelant
04-02-2002, 08:58 PM
How can i not allow for a user to enter letters in a number field the moment that he is tiping them.
|
View Full Version : No letters in a number field Roelant 04-02-2002, 08:58 PM How can i not allow for a user to enter letters in a number field the moment that he is tiping them. Geoff Codd 04-02-2002, 11:56 PM Check the help files for input masks, there you can specify what type of Characters you can enter into a field Roelant 04-03-2002, 01:08 AM It is not possible to put a input mask on an numeric field. Are there other possibilities to do this witch fields how are linked to a numeric field in a table. Geoff Codd 04-03-2002, 01:32 AM Sorry about that you could put <>0 in the validation rule field of the table this will only allow a value that is greater than 0 to be entered and returns an error message if you enter text [This message has been edited by Geoff Codd (edited 04-03-2002).] Roelant 04-03-2002, 04:30 AM Thank you, but I tried this already and it works good, but what I want is that the field not allowed to type letters in this numeric field just like a input mask does in a text field, Can someone help me ? David R 04-03-2002, 07:31 AM Your user won't be able to finish the field anyway if they try to type letters into a numeric field. Trap the error message and make your own custom "hey stupid" message if you like. Failing that, look into this topic about using the KeyPress event: http://www.access-programmers.co.uk/ubb/Forum3/HTML/003254.html David R Roelant 04-03-2002, 09:38 AM Thanks works great |