Show or hide a comment based on a field information

[Secue]

I have a form using fields from a table. One field is a Yes/No type. I need to show a message that stays on the form if the YES/NO field is True, if the field is false I want to hide this comment. I tried adding the coment as a label. When I open the form I want to evaluate the YES/NO field. If it is true I want show the alert message on the form (I do not want to use a msgbox) and need this message visible all the time that the user is working on the form. If value of the field is False, then I just do not want to show the alert message.

Not sure if I'm clear on my need.

I think I can do it changing the property of the label, but not sure how to do it on VBA.

Thank you.

[June7]

Changing control properties with VBA will not work nice with Continuous or Datasheet view. The change will be reflected in ALL records because there really is only one control.

If the form is Continuous or Datasheet, create a field with expression in a query that serves as the form RecordSource.

AlertMsg: "Your message here."

Bind a textbox to this calculated field. Use textbox Conditional Formatting to set ForeColor same as BackColor.

Otherwise, VBA:

Me.labelname.Visible = Me.checkbox

The real trick is figuring out what event(s) to put the code in. Maybe the form Current and/or the checkbox AfterUpdate.

[Secue]

Thank you. second option worked for me.