Conditional Formatting

[ccordner]

Hi

I am trying to highlight fields are above or below target using conditional formatting.

The expressions I have used are:



[OvertimeHours]>"txtTargetSoFar"

and

[OvertimeHours]<"txtTargetSoFar"

Where OvertimeHours is a column in the query the report is based on and txtTargetSoFar is the name of a field on the report.

Any ideas why this isn't working? They are both applied to the same field and it just doesn't apply any formatting.

Thanks
Chris

[Bob Fitz]

Have you tried without the Quotation marks
[OvertimeHours] > [txtTargetSoFar]

[ccordner]

Thanks, yes, I've tried that: still with no success.

I have yet to get conditional formatting working with Access!

Thanks
Chris

[TheShabz]

Try [QueryName]![OvertimeHours] > [txtTargetSoFar]

[ccordner]

Thanks, but if I do that when I run the report I get an inputbox asking to enter a value for qryOvertimeWorked.

[ccordner]

Just been experimenting. Can't even get it to work with "Cell Value is less than 10". This is bizarre!

[ccordner]

Just been experimenting. Can't even get it to work with "Cell Value is less than 10". This is bizarre!