Accept numeric input only in textbox

  • Thread starter A.J.M. van Rijthoven
  • Start date
A

A.J.M. van Rijthoven

Is there an easy way to accept only numeric input in an unbound field.
I want to be able to search a specific record by number. When I enter
a letter, the query gives an inputscreen assuming that the letter is
part of the querysearch...
To prevent this I want to accept only numeric input in the unbound
'search field'. How do I do this??

Thanks in advance
 
K

Klatuu

Set the Format property of the text box to 9999 (or how many digits are
required). You can find more detailed info in VBA Help
 
Top