Change Background colour if tick box is ticked

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

Guest

Hi,
I have a subform that shows results of a combo box, the subform contains CD
information linked to a customer selected from the combo box. I book the CD's
out to certain people and want to flag if the CD is booked out. I book out
the CD by ticking a yes/no tickbox.

I don't know where to start as I can't even test the value of the checkbox!
I presume if it is blank then it is 0 and if it is checked it is 1.

Please help!
 
Ok, I have managed to get a text box to tell me on the afterupdate value of
the tickbox, whether or not the box is ticked.
All I need now is to be able to change the background colour of [date] if
the tickbox = yes

Thanks

RIch
 
hi.
something like this should do it.

If me.tickbox1 = true then 'the box is checked
me.txtdate.backcolor = 255 'red
else 'the box is not checked
me.txtdate.backcolor = 16777215 'White
end if
-----Original Message-----
Ok, I have managed to get a text box to tell me on the afterupdate value of
the tickbox, whether or not the box is ticked.
All I need now is to be able to change the background colour of [date] if
the tickbox = yes

Thanks

RIch

Richard Smith said:
Hi,
I have a subform that shows results of a combo box, the subform contains CD
information linked to a customer selected from the combo box. I book the CD's
out to certain people and want to flag if the CD is booked out. I book out
the CD by ticking a yes/no tickbox.

I don't know where to start as I can't even test the value of the checkbox!
I presume if it is blank then it is 0 and if it is checked it is 1.

Please help!
Click to expand...
.
Click to expand...
 
Try using conditional formatting on the text box to assign a background
color based on the value of the checkbox.

Richard Smith said:
Ok, I have managed to get a text box to tell me on the afterupdate value
of
the tickbox, whether or not the box is ticked.
All I need now is to be able to change the background colour of [date] if
the tickbox = yes

Thanks

RIch

Richard Smith said:
Hi,
I have a subform that shows results of a combo box, the subform contains
CD
information linked to a customer selected from the combo box. I book the
CD's
out to certain people and want to flag if the CD is booked out. I book
out
the CD by ticking a yes/no tickbox.

I don't know where to start as I can't even test the value of the
checkbox!
I presume if it is blank then it is 0 and if it is checked it is 1.

Please help!
Click to expand...
Click to expand...
 
Back
Top