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
 
Back
Top