How do I make a label visible when the check box is checked?

B

Big Bill

I have a form that we verify if it has been checked if it is checked than we
can'
t ship the product. How do you get this to refelect for each individual
record.
 
J

John Vinson

On Sun, 3 Apr 2005 18:23:01 -0700, "Big Bill" <Big
I have a form that we verify if it has been checked if it is checked than we
can'
t ship the product. How do you get this to refelect for each individual
record.
Click to expand...

A sneaky way is to put a textbox on the Form, bound to the yes/no
field in the table; set its Format property to

"";"Verified, Ready to ship"[Green];"You can't ship this yet[Red]";""

The "four value format" has different formats for positive, negtive,
zero and NULL values; a Yes/No "checkbox" field will never be positive
or null, but will be -1 if True and 0 if False.

John W. Vinson[MVP]
 
Top