Conitional formatting on a checkbox

[dgwils]

I am trying to set a conditional format within a form so that if a [banned] checkbox is ticked another control will show as a red background. I have tried expression is but no change occurred. Any help would be greatly appreciated, thanks in advance.

 

[lcook1974]

Have you tried writing a VB code in the after update event of the "checkbox"

Something like:

if me.[banned]checkbox = true
then me.othertextname.backgroundcolor = red
End if

you'll probably have to play around with the syntax but I think that would do it for you.

 

[vbaInet]

Also add an Else statement to set it back to the default colour.

 

[dgwils]

Thank you very much I will try that and will post.

 

[missinglinq]

This type of code will only work in a Single View Form, not in a Datasheet or Continuous View Form. In those type of forms you'll have to use Conditional Formatting. After selecting the texbox to be formatted you'd go to Format - Conditional Formatting and use

Expression Is

[BannedCheckboxName] = True

then select the backcolor Icon and selct red from the palette.

 

[dgwils]

Thank you very much, it worked a treat although I had to rename the checkbox to make it work.

 

[missinglinq]

Glad we could help!