Textbox Validation

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Dear Users,

I would like to configure a text box such that it does not accept decimals
but accept only whole number. Any ideas?

Kind Regards
Charles
 
For a simple approach, just use
Not Like "*[!0-9]*"
for a validation rule.

If you want to go the whole hog, you may need to decide how to handle
thousands separators (e.g. is 1,000,000 a valid entry - or in some
countries 1.000.000 or 1 000 000) and exponents (e.g. is 1.25E6 -
1,250,000 and therefore a whole number - a valid entry).
 
Back
Top