Form that checks input formatting?

[Kevin-anderson]

I have a form that lets a user input additional records into the database; however, different users are using different formats. Is it possible to prompt the user if the formatting is not correct. For example employee ID numbers are 5 digits with an "E" in the front ("E00000''), and many people are simply entering the information without the E. Any suggestions?

 

[SOS]

You can use an input mask -

\E00000;0_

(untested)

 

[CEH]

Maybe something like this on the before update of your textbox will give you some ideas..........

Dim strValue As String
Dim strLeft As String

strValue = "E"
strLeft = Left(strValue, 1)
If strLeft = Left(yourTextBox, 1) Then
MsgBox "yes it is E"
Else
MsgBox "No it is not E"

End If