Please help with Conditional Formatting

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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 said:
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?
Click to expand...


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.
 
Thank you very much for your help. It works great!

Marshall Barton said:
TotallyConfused said:
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?
Click to expand...


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.
Click to expand...
 
Back
Top