MS Access - Validation Rule

[selvakumar.arc]

I want to apply validation rule in my text box, can you let me know how can I implement this?

1. txtStatus will accept only one character, acceptable character is "T", else throw an validation message
2. txtStatus will accept empty value and donot throw any error in this scenario

Acceptable characters are = "T" or ""



The "txtStatus" columns is one of the column in the Datasheet Form.

Regards,
Selvakumar R

[azhar2006]

Hi ,selvakumar
http://office.microsoft.com/en-us/ac...5.aspx?redir=0

[selvakumar.arc]

Thanks for you information.
I applied following and it is working
([txtStatus]="T") Or Is Null

[azhar2006]

Very good
I wish you success in your project