No letters in a number field

[Roelant]

How can i not allow for a user to enter letters in a number field the moment that he is tiping them.

 

[Geoff Codd]

Check the help files for input masks, there you can specify what type of Characters you can enter into a field

 

[Roelant]

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]

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]

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]

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]

Thanks works great