how to check a checkbox using a button in a continuous form

[rocklee]

Hi folks,

I am using checkboxes for a table that I use to toggle yes/no. It is being used in a continuous form however the checkboxes are a little small so I would like to use buttons instead but still check these boxes.

Any ideas?

 

[rocklee]

Nevermind, I figured it out. I set the value of the checkbox to 0 (true) or -1 (false) and each row is controlled by its own button in a continuous form.

 

[rocklee]

I can change the status of the checkbox, but now I can't change the color of my fields. It will change the entire column of the same field type. Is there a way to change only the field colour in the selected row?

 

[pbaldy]

Look at Format/Conditional Formatting (on the ribbon in 2007).

 

[rocklee]

Thanks Paul, I was hoping to use form referencing in VBA to do this instead of conditional formatting.

 

[rocklee]

In fact I realised I can't use conditional formatting on labels/boxes.

 

[pbaldy]

Code based formatting is easy on a report, not so easy on a continuous form. I believe ChrisO has posted something along those lines, so you might search for conditional formatting and specify him as the user.

 

[rocklee]

Thanks again.

I've decided to color code the fields themselves using CF to highlight attendance/non-attendance instead of a background box.