changing the color of a box

[Andy Levy]

Hi

I have a continuous form in access. Each record has a tick box. What i
would like is to change the backcolor of a rectangle dependent on whether
the value of the checkbox is Ticked or Not Ticked.

Hope you can help.

Thanks
AL

 

[Dennis Schmidt]

Hi Al,

My name is Dennis Schmidt. Thank you for using the Microsoft Newsgroups.

If you are using Access 2000 and above, you can use the Conditional
Formatting option (Format menu, Conditional Formatting). Use the
"Expression Is" option, test for the value of the checkbox field and set
your background color.

If you're using a version pre Access 2000, you don't have an option to do
this. Changing the background color of a control on a continuous form will
make all the records that color.

I hope this helps! If you have additional questions on this topic, please
reply to this posting.

Need quick answers to questions like these? The Microsoft Knowledge Base
provides a wealth of information that you can use to troubleshoot a problem
or answer a question! It's located at
http://support.microsoft.com/support/c.asp?M=F>.

This posting is provided "AS IS" with no warranties, and confers no rights.
You assume all risk for your use. © 2001 Microsoft Corporation. All rights
reserved.

Regards,
Dennis Schmidt
Microsoft Support

 

[Andy Levy]

Wow - Thanks

Ive spent the past 12 hours working out a vbscript that will individually
build the box on the screen with individual name ids.

This Conditional Format facility you posted is much better.

Thanks