textbox font color dependent on check box

[Chimp8471]

i have a report which i need to make certain results displayed in Red, if there is a check in the box.

example:

my report is called OEEModel
on the form i have a chkbox - called "FailureModeInPlace"
i also have 2 text boxes called "EventCode" and "CodeDescription"

what i want to do is for each record that is displayed with a chkbox ticked that the font in the two boxes turn red and bold...

can this be done please if so...how

cheers

Andy

 

[The_Doc_Man]

On a report you have a format event for each SECTION of the report - whether it be a header, footer, or detail section. In the OnFormat event, you can put code that will allow you to make changes to the properties of selected controls IN THAT SECTION ONLY.

So, for example, if the check box and the text box are in your detail section, then in your OnFormat for the detail section, you would have code that tests the check box value and adjusts the text box properties. Bold and ForegroundColor are available to you at that time, so you could set them as appropriate - or clear them if that is what they need to be.