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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Change the font color/background of a text box depending on value 6
Access How to record date/time when specific field is modified in Access 2007 0
Conditional text box coloring 1
Need combo box to refresh when moving to new record 2017 1
Subform Null Values 1
Combo box formatting question 4
Prevent Full String Selection after Change Event on Control 1
Delimit dates - how? 1

Back
Top