changing text color when matching

  • Thread starter Thread starter JeffMKlein
  • Start date Start date
J

JeffMKlein

I have a text box on my form that shows a record date. I also have a query
subform that returns several record with dates. What I am looking for is a
way to hilight or change the text color of my text box when the query
includes this date in its recordset. Any suggestions?
 
You could try using the DLOOKUP function to check whether the date in the box
exists and if so change the forcolour/background colour etc if it does
 
Back
Top