Conditional Format - Specific Date

[MrsCurtis]

I have a report with training dates.
I would like the report to format any fields with the date 01/01/2001 in yellow
Does anyone know the expression to use?

This feels like it should be simple but has been driving me mad for days.
Hoping someone can help
Ali

 

[lightray]

right click on the field in design view, conditional formating et al is there!

as a design feature yellow is not a good colour to use on a white page, lightray

Edit: perhaps not conditional for reporting!

 

[MrsCurtis]

Thanks lightray

But i think you misunderstood me.
I know how to use conditional formatting (the field in question already has two conditions which work fine).

What i am after is the 'expression' to use so that conditional formatting will return results when the field reads the specific date 01/01/2001

Any ideas?

 

[lightray]

then try a search on color or colour, plenty there!

this one first off the rank!
http://www.access-programmers.co.uk/forums/showthread.php?t=117601

happy colouring

 

[boblarson]

If you already know how to use conditional formatting and the field's datatype is a date, then just select a conditional format of:

Field Value Is -- equal to -- #1/1/2001#