On Fri, 21 Nov 2003 07:52:44 -0000 in comp.databases. ms-access,
"Lapchien" <cc****@nospamp lease.eclipse.c o.uk> wrote:
One of my users has asked that a form change it's colour if a particular
yes/no box is ticked - possibly made a bit more tricky because the form is
tabular..?
By tabular you mean datasheet or continuous forms?
If datasheet then you're out of luck.
If continuous forms I assume you want different background colours on
different rows?
Create a textbox with no label, make it a big mutha that spans the
whole form, set it's controlsource proeprty to something like:
=IIf([MyCheckBox],String(30,103) ,"")
Set it's font to Webdings, size large enough to fill the whole lot.
Set it's *forecolor* property to the colour you want the back of your
form for when the checkbox is checked and backcolor to whatever you
want for normal (or make it transparent to inherit the form's
backcolor).
Use format menu, send to back.
--
A)bort, R)etry, I)nfluence with large hammer.