changing text color when matching

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?
 
C

Chris

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
 
Top