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