Date Field

[dsthome]

Hi just wondering if the following was possible. In a date field is it possible for a date that is in the future to be hi-lighted in a different colour.

eg todays date is 25/03/14

So anything with todays date or previous would stay in black

24/03/14
25/03/14

but anything from 26/03/14 forward would be in red

26/03/14

Then will change to black when the 26th comes

Thanks

 

[pbaldy]

In a form or report you can use Conditional Formatting.

 

[dsthome]

What an idiot didn't even think about that thought it would be more complex. Over thinking again. Sorted now thanks.

 

[pbaldy]

No problemo!