text only input mask

B

BeckyM

I thought I could do this through an input mask but now I'm not sure. I need
an input mask that does not allow numbers. Alpha is OK and alphanumeric is
OK but raw numbers (integers or decimal) is not. Tried messing with A??? but
that disallow any alphanumeric as far as I can tell. Any suggestions via
input mask or VBA?
 
G

Graham Mandeno

Hi Becky

I suggest the BeforeUpdate procedure of the textbox:

If IsNumeric(TextBoxName) Then
MsgBox "Entry cannot be entirely numeric"
Cancel = True
End If
 
J

JL

Hi BeckyM,

I lookup help on "Input Mask" and click on "Examples of input masks". There
are alot of useful information. Like "L" is Character only.

Hope this helps.
 
Top