Richard I'm trying to create a report log that will grey out the entries once the date, starttime and endtime is past. i.e.
startdate = 4 May 11 and starttime is 10:30 endtime 11:00 once the system clock goes over 11:00 I want that entry on my report to be greyed out.  what's the best way to implement this?
Thanks

---

Reply from Richard Rost:

I would use a little bit of VBA code in the Build Event for the section. Something like:

If StartTime < INSERT_TIME_HERE Then
   MyTextBox.BackColor = COLOR_CODE_FOR_GRAY
else
   MyTextBox.BackColor = COLOR_CODE_FOR_WHITE
end if

Of course, you'll have to insert the right color codes and variables/field names in there, but that should get you started. I cover this in one of my lessons. Not sure which one. If you need it, let me know and I'll figure it out. :)