Please help with Conditional Formatting

I can't seem to set conditional formatting with a check box on a form. I
want to be able to highlight row in form if checkbox is checked. Can this be
done without using code? Newbie to VB. Any help will be greatly appreciated.

TotallyConfused wrote:

I can't seem to set conditional formatting with a check box on a form. I
want to be able to highlight row in form if checkbox is checked. Can this be
done without using code?


You don't want to conditionally format the check box (which
is pretty useless anyway), you want to format something else
depending on the value in the check box.

You can not conditionally format the form's (Report?) detail
section, but you can add a large text box that's sized and
positioned to filee the detail section. Set its Conditional
Formatting - Expression Is option to [thecheckbox] = True
and then use Format - Send to Back to move the text box
bhind all the other controls. Youwill probably also want to
set some of the other controls BackStyle property to
Transparent.

--
Marsh
MVP [MS Access]

Thank you very much for your help. It works great!

"Marshall Barton" wrote:

TotallyConfused wrote:

I can't seem to set conditional formatting with a check box on a form. I
want to be able to highlight row in form if checkbox is checked. Can this be
done without using code?


You don't want to conditionally format the check box (which
is pretty useless anyway), you want to format something else
depending on the value in the check box.

You can not conditionally format the form's (Report?) detail
section, but you can add a large text box that's sized and
positioned to filee the detail section. Set its Conditional
Formatting - Expression Is option to [thecheckbox] = True
and then use Format - Send to Back to move the text box
bhind all the other controls. Youwill probably also want to
set some of the other controls BackStyle property to
Transparent.

--
Marsh
MVP [MS Access]