Conditional formatting Access 2007

[suepowell]

Hi I am trying to use the conditional formatting button in the formatting menu of Access 2007.

Putting the format on is similar to earlier versions, and I can do this. However it doesn't seem to work.

What I am trying to do is colour a field if it's value is before today. When I put in the expression it seems happy, but when I show the report in print preview I get no colours.

I have found that when the report is in report view I can see the colour if I click on the field, and it changes correctly as I click on the field in the next record. I only get the colour for the field I have actually selected.

This is obviously no use for printed reports and as I cannot imagine what use this feature could be I assume I'm doing something wrong.

Does anyone know of a global setting or anything else that I could be missing.

All I want is a printed report coloured to show what jobs are late, something it was easy to do in previous versions of access, so I'm sure it is possible in access 2007.

Thanks for your thoughts.

Sue

 

[suepowell]

Hi again, panic over.

I have just discovered that you have to specify a default condition before it will apply the others.

As it shows a default setting at the top of the page I assumed that was already done, but if you actually specify the default then it applies all the conditional formatting.

Hope this ramble is of use to someone esle.

Sue

 

[huilmn]

Thanks for that. I've been trying 2007, and couldn't get the backround colour to come up, until now.

 

[Minddumps]

Same for me, I had even opened up another thread bc I couldn't find it... then I came across your post FINALLY! lol thanks!