validation

hayden

Registered User.
Local time
Today, 08:04
Joined
Mar 16, 2010
Messages
49
In the design view of the tables at the bottom i have put validation in, with a personalised message too. How can i enter another validation and another tailored message as this is what is needed,
how do i do length check too??
 
You could do a number of logical tests on the data, using the field's Before Update event, and and create you own custom message for any eventuality.

The code would look something like;
Code:
If Me.FieldName <> [I][COLOR="Red"]Your Validation test[/COLOR][/I] Then
     MsgBox "Your Customs Message"
     Cancel = True
     Me.FieldName.SetFocus
End IF
 
Last edited:
  • Like
Reactions: SOS

Users who are viewing this thread

Back
Top Bottom