Text Conditioning on Report Control

[trustsun]

I need to see a value highlighted when it has reached 10:00 AM. I am having trouble formatting it correctly. It would need to be; mm/dd/yy hh:mm:ss. Remember it will be on any given day.


Here's what I got so far;

If Me![lastdatetime] >= 10:00 AM Then

 

[randysmid]

Hi,
What is the format of your field "lastdatetime"? Obviously, if your field includes a date, then checking for >= 10:00am will not work, will it? Perhaps the best thing is to go into debug mode, and as soon as the line executes, place your cursor over the [lastdatetime] to see the actual format being returned to the code.
HTH, Randy

 

[dhookom]

Have you tried Conditional Formatting. You can set the Expression is to:
=TimeValue([LastDateTime])>#10:00 AM#

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]