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

rocklee

Registered User.
Local time
Today, 13:19
Joined
May 14, 2009
Messages
36
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?
 
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.
 
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?
 
Look at Format/Conditional Formatting (on the ribbon in 2007).
 
Thanks Paul, I was hoping to use form referencing in VBA to do this instead of conditional formatting.
 
In fact I realised I can't use conditional formatting on labels/boxes.
 
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.
 
Thanks again.

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

Users who are viewing this thread

Back
Top Bottom