How to change color on text using IF

[PoorCadaver]

Sorry, but I have to re-open this case again...

What about if I want field1 to change color considering the value of field2?

 

[SmallTime]

Look at conditional formatting.

 

[PoorCadaver]

Sorry, but I can't find anything else there but to only read the value of the chosen field.

 

[SmallTime]

Make sure 'field1' is checked then either right click or in the ribbon select the format tab and then click conditional formatting. When the conditional formatting form opens click 'New Rule'. You'll want 'Expression is" in the first (leftmost) dropbox then use the wizard to set the expression to something like [field2] ="WHATEVER", then select the format you want if the expression is true.

Good Luck

 

[PoorCadaver]

I have an old version of Access (2000) so there is no wizard. Only a text box. I have tried a couple of expressions but can't find onyone that works. They look like:

tblUnit.IsUsed=-1

 

[SmallTime]

Here you are

 

[PoorCadaver]

Thanks! It works now. What I had forgot was to add the field in the query... ^^