text only input mask

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

Guest

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?
 
Hi Becky

I suggest the BeforeUpdate procedure of the textbox:

If IsNumeric(TextBoxName) Then
MsgBox "Entry cannot be entirely numeric"
Cancel = True
End If
 
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.
 
Back
Top