Hi All,

I am trying to add some conditional formatting to a continuous form but it is not going well.
I am trying to get the text colour from column record from 'A' to change based on the value in column record 'B'.
sofar I have gone in the conditional formatting of column 'A' and added the expression
it doesn't wanna work for me and I am now at a loss of what to try next.

note column 'B' is a tick box

Regards,

Joseph Williams

Welcome to P2P. I don't understand the use of 1 and 0 (zero) as it applies to conditional formatting for colors.

If you're using conditional formatting, then you'd set it in the dialog box that if the cell contents of column A equals to [Column_B] then you'd set the color of the font to some color.

What you wrote here looks more like an iif statement for a control, a query, or VBA... not conditional formatting.



Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division

Hi Greg,

IIF statement I got based on another post in the forum I'm not 100% sure it is right

the problem I have is column 'A' is a text field while column 'B' is a tick box.

what I want to happen is the text in column 'A' to change colour if there is a tick from column 'B'.

If it was just a single form I'd do a bit of VBA but with it being a continuous Form if one record triggers the colour change, the colour changes is applied to all records display in the form.


what I am really asking is, Is there a way to colour individual records in a continuous form using my criteria.

Regards,

Joseph Williams

Well column B is a checkbox (true or false, -1 or 0, yes or no). In the form's design view, click the textbox. In there, choose Format > Conditional Formatting. It the dialog that opens up, choose for condition 1: "Expression Is". In the box to the right, type in the name of the field that is the control source for the checkbox, e.g. MyCheckbox like this:

[MyCheckBox] = True

Then enter the formatting you want below that with the buttons.


Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division