New Check Box Issue

[Kembo]

I received the following help on Check Boxes earlier so
that I could flag a mnessage for errors with a check box
linked toi a text box...

Another option would be to have a text box with an if
statement in it. The
box would have no outline and the background would be
transparent. if the
checkbox is true, then put some text such as "Error" if
the checkbox is not
true, then make the value blank "". For example...

=IIf([CheckBoxNameHere],"ERRORS ON RECORD","")

But now, whenever I check a record, it applies to all
records. If I deselect the box, no records are marked...
I want to be able to apply this to individual records.
Any Help?

 

[John Vinson]

But now, whenever I check a record, it applies to all
records. If I deselect the box, no records are marked...
I want to be able to apply this to individual records.
Any Help?

If you have a Yes/No field in your table you can set up a textbox
bound to that field, with a Format property of

"";"";"ERRORS ON RECORD";""

Since true/yes/checked is stored as -1, this numeric format will
display ERRORS ON RECORD if it's checked and blank otherwise.