Searching for a value in datasheet column

[scubafrog79]

I was wondering how I can look through a datasheet that is a sub-form to find a record based on date. So when I open my form, it looks at the sub-form and loops through the records and when it finds a row with today's date, it changes the background and font color but puts it back to the normal background and font color when it's not today's date

In this example,the row where Mary is listed would change colors since today is the 27th of December 2019.

 

[dhookom]

Do you really have a field named "Date". This is a function and should not be used as field or other object name.

You should be able to use conditional formatting.
Set the Expression Is to:

[Date Field Name]=Date()

And then set the background to kinda red.

Duane
Minnesota
Hook'D on Access
MS Access MVP 2001-2016

 

[scubafrog79]

Thanks, didn't realize Access had conditional formatting like Excel.

 

[dhookom]

Scubafrog79, is your question answered or do you need more help?

Duane
Minnesota
Hook'D on Access
MS Access MVP 2001-2016