Hi, I have an access form that needs validation. I can get it to work but get errors if they go back and delete whats in field one. Field one is a number field. Field two must be "M", "G" or "T" is something is entered in field one. Using the validation rule and validation text works fine until they decide to delete field one - field two still wants M, G or T. I am using
Like "M" Or Like "G" Or Like "T" - for the rule and
"Enter M for Megs, G for Gigs or T for Terabytes" for the text.
How do I validate field two only if there is something in field one and allow them to go back and delete if they change their mind. Please help! Thanks, Lisa
Like "M" Or Like "G" Or Like "T" - for the rule and
"Enter M for Megs, G for Gigs or T for Terabytes" for the text.
How do I validate field two only if there is something in field one and allow them to go back and delete if they change their mind. Please help! Thanks, Lisa