Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Edit inputmask error message

Status
Not open for further replies.

marsss

Programmer
Sep 24, 2004
116
US
Hello,

in one of my form i got a text box with a inputmask. This mask is set to receive 5 digits only.

After that, when i want catch this value in my VBA code, it prompt a error msg if the value in the text box isn t coresponding to the inputmask.

What i want do, is edit this msg that is prompt, so I could tell the user with more userfriendly message than the default one

Is it possible to do? Or might be better do my own mask inside VBA code instead
 
The input mask will use its own error message - you could check the field as follows:

If Len(Me.txtEntryField) <> 5 then
MsgBox "This entry is not correct......."
Me.txtEntryField.SetFocus
Me.txtEntryField = Null
End if

Frank J Hill
FHS Services Ltd.
frank@fhsservices.co.uk
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top