Conditional Formatting

[schwabe]

Hello all,



I'm trying to set up my report, such that it shows products which are not available in red and the ones available in black.
I'm trying to use the Conditional Formatting function for this.

The datastructure below the report is a query called qrySFReport.
the qry has the fields:
- txtProductName
- datDueDate
- txtProjectName
- intQuantity
- logAvailable

The report itself is grouped with respect to the product name and for each group I am giving Due Date, Project Name and Quantity.

I'd like to establish two different functions:

- I want the whole paragraph to be colored in red, if the product is not available. Using the expression based rule [qrySFReport].[logAvailable]=False does not work. How do I do that properly?
- For Dates in the past, I'd like to have the wohle line colored in grey. I know how to do that for the date field (simply use a Field Value based formatting rule).

My basic problem is, that I don't know where to find the values...

Benjamin

[June7]

You are using Conditional Formatting dialog? This should work.

Expression is: [logAvailable]=False

If you want entire row to reflect alternate format, must set Conditional Formatting for each textbox. If you want an unbroken background bar across the row, will need a textbox layered behind all the other controls (set those controls as Transparent). Then can apply Conditional Format to this textbox.

[schwabe]

Hi,

thanks, that solves the problem. I didn't realize that Access is converting logAvailable to a string, when I don't put the brackets...