Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Validate field 2 text if field one is not emplty

Status
Not open for further replies.

Eprice

Technical User
May 6, 2003
209
US
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
 
How are ya Eprice . . .

What are the actual names of the form, Field1, Field2?

See Ya! . . . . . .

Be sure to see thread181-473997 [blue]Worthy Reading![/blue] [thumbsup2]
Also faq181-2886 [blue]Worthy Reading![/blue] [thumbsup2]
 
Why not using a combobox with only choices of those chars?

Limit To List = Yes

Zameer Abdulla
 
The fields refer to hard drives and ram slots for servers, mainframe and computers so I thought there might be an easier way to just copy and paste from one field validation to another and change the name. I did think of the combo box and that is what I'll probably have to do but it will be quite a bit more work. Thanks anyway. Lisa
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top