Form color change

[WhipStitch]

I am wanting to set up a function to where if a checked box is clicked the forum that it is connected to changes background color or has a color change to make it stand out.

I know it can be done, I am just hitting a block and need help.

 

[Uncle Gizmo]

When I saw your question I thought of this video I did recently, it isn't quite what you wanted but it might give you a start:-

MS Access - Generic Form Colors

 

[arnelgp]

You put code on the checkbox after update ever:

Private sub chkbox_afterupdate()

Me. Detail.back color=iif(chkbox, vbYellow, vbwhite)

End suB

 

[WhipStitch]

Thank you both.

Is it possible to change the color back? Like a second click to turn the background back to white?