Limiting text data type to numeric input

[ctdak]

Can a text box control with a text data type source be limited so as to only
allow the user to input numeric characters (no alpha or special characters)?
I have need to allow the user to input up to a 14 digit number which is
larger than a long integer data type can handle, so I'm using a text data
type.

ctdak

 

[ctdak]

Linq,

Thanks so much. This is exactly what I needed. I had not used this event
procedure before. One thing I noticed was that tabbing out of the field does
not require the "Or (KeyAscii = 9)". Tabbing out is no problem, but tabbing
into the field does need this added to the test or else the message comes up.

ctdak