Hello
In a text box, I would like the user to be able to enter only a number from
0 to 100 (including decimals Ex: 24.56) so I wrote this in the Validation
Rule Propertie
of the text box : >= 0 And <=100
This works good when the user enters numbers in the text box but when
letters are entered
Access displayed a default message instead of the Validation Text message.
How would I write the Validation Rule so the exclude all letters and include
all numbers from 0 to 100
including decimals?
I am using MSAccess 2000
Thanks
G.Gerard