Validtion Rule

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

Guest

Hello,

I have a TextBox & I want to set its Validation Rule to check if the 1st 2
characters are = "CC" & if so to then display a message otherwise do nothing.

I know you can use LEFT function to get the 1st 2 characters, but what is
the syntax to enter in the Validation Rule Property ?

Also I know this check can be done in the Before Update or After Update
Events but I would like to know how to do this using "Validation Rules" so I
dont have to code anything.

Any help would be greatly appreciated.

Thank you,
Jeff
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Validation rule using calculated value from another subform 3
How can I allow hyphen (or dash) in this validation rule? 1
Validation Rule 1
Validation Rule 3
Validation Rule 1
Multiple Validation Rules 1
Custom validation rule 4
Validation Rules for a Control on a Form (?) 4

Back
Top