Validate for text and numbers?

[Lamb2087]

I have tow separate functions to validate for either numbers or text. Is there a way to allow a text box to get both. I want an "a" tp proceed the 5 digit number?

I can post what I have for validation so far that works if needed.

Bill

 

[Mile-O]

An input mask on your textbox will give you what you want:

L00000 as your input mask will allow one letter and five numbers.

Is this what you want?

 

[Lamb2087]

I get a dialog box stating " The field must contain numbers with A proceeding the numbers"

I type in A213312 a sequence of any 6 digit number and get this error. I am putting in the text box what it needs and still get an error mesage and ideas?

I have put L000000 in the Input Mask

 

[Lamb2087]

Works now

I forget I had this sub routine

Private Sub txtNMMI_NUM_BeforeUpdate(Cancel As Integer)
If Not IsNumeric(Me![txtNMMI_NUM]) Then
MsgBox "The field must contain numbers with A proceeding the numbers"
Cancel = True
Me![txtNMMI_NUM].Undo
End If
End Sub

 

[Lamb2087]

Date - Input Mask

I have this for the input mask for a date text box

99/99/00;;

When I enter the date I can not move from the text box, essentially you are stuck there.