Hello all

been a long while since I have visited this site, trying to remember all I have learned....lol

My question:

I have a form,"continuous" based on table records, I am trying to insert a checkbox that when checked will color a specified cell in the form, I have figured out how to do this on a small test DB I built, but here is the issue, it colors all the cells corresponding to the label. Any way from within the cell to just color the cell individually?.........

This is a pickup / delivery database for a transportation company, built by another developer who no longer works for this company.

I want to signify that the "pickup, or delivery" is complete on the continuos form is completed................this form will be visible to multiple dispathers...........FE/BE is up and running. This is currently being done manually with a handwritten sheet and highlighter................


TIA

Will

Sounds like you need to use conditional formatting.
Here's a link on details for doing it in Access 2007. And a link for Access 2003.

Hope that helps. Note that you can't do conditional formatting on a checkbox itself; however, sounds like it's another control that you want to conditionally format.

Hello

Thanks for the info, I do not believe I can do this on a form, whether "single", or "continuous", it just changes the background color on all the "corresponding" labels. I need it to just change the color when the checkbox is selected, for the "single" corresponding CompanyID for the individual pickup



Will

As long as you're using a version of Access that supports conditional formatting (Access 2000 and later), this will in fact allow you to change the background color depending on certain values (for instance, if a check box is checked) while not doing so on other values. I've done it before and know it works. For instance, I have a form that shows how many days are left until something expires, and within 90 days of expiration the value is colored yellow and within 30 days it's red. However, for other values it has no coloring at all.

Ok

I will look a little closer at the conditional formatting, I need only "individual" records to change color, when the checkbox is selected it signifies the pickup is completed............right now, on my form, whether single or continuous it is simply coloring all the company ID's cell..............


Will

Here's a real simple database that highlights a text box in blue if a check box is marked and is white otherwise.

Fletch

works like a charm, thanks much

Will

Great, glad it helped!

I hope no one minds if ZI jump in here....

I downloaded your sample and I see that checking the box changes the color but where is the code behind the color change?
How do you do it?

Hi Larry,

I haven't looked at the demo but Conditional Formatting doesn't use any code. That's what's good about it.

Just my 2 cents... (IMG:style_emoticons/default/2cents.gif)