Check Boxes

  • Thread starter Thread starter Kembo
  • Start date Start date
K

Kembo

I'm trying to make a checkbox on a page light up a box or
display a picture to indicate that the record is
incomplete or has errors. I just cannot seem to make it
work as of yet, any help?
 
To "light up a box", I assume you mean change the font in it?

Just use conditional formatting to say if the checkbox is true, then format
the font to RED or bold, or whatever you want to do.


----------------------------------------------------------------------------
--
To modify the visible property you could insert code in the after update
event and the oncurrent event of the form to say if the checkbox is true,
then the .visible property of some object is true.

Private Sub Form_Current()
If [CheckBoxNameHere] Then
Me!SomeControlNameHere.Visible = True
Else

Me!SomeControlNameHere.Visible = False
End If
End Sub


----------------------------------------------------------------------------
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","")

----------------------------------------------------------------------------
----


Let us know if you need specific help on any of these.

Rick B



I'm trying to make a checkbox on a page light up a box or
display a picture to indicate that the record is
incomplete or has errors. I just cannot seem to make it
work as of yet, any help?
 
I am using your third option about the If command text
box, but now the problem is, it applies it to every
record. If I turn it on, it goes through all the records
to say they have an error, if I uncheck it, it won't mark
any errors.

New Help?
 
Is this a form viewing a single record? A continuous form? Or a subform?

I am using this exact method on a single form and also on a continuous form
and it works well.


Rick B

I am using your third option about the If command text
box, but now the problem is, it applies it to every
record. If I turn it on, it goes through all the records
to say they have an error, if I uncheck it, it won't mark
any errors.

New Help?
 
Back
Top