Visible= Yes/No

  • Thread starter Thread starter Andy
  • Start date Start date
A

Andy

Hi;

Have a situation where a control is set to Visible=No until a checkbox is
clicked then the control becomes visible.

That works. The obstacle is that it makes the control visible in all of the
records.

Only want the control visible in the records where the checkmark is True.

Any suggestions?

Thanks in Advance.

Andy.
 
if this is a single form, you need to insert your code in the OnCurrent
event so that it is executed when you move from one record to another.

If it is a continuous form, then I do not think you can do it that way. You
might be able to make an unbound text box and inset and IF statement that
diplays the control if the checkbox is clicked and displays "" if not, but
you would not be able to update the data in this example.

Rick B


Hi;

Have a situation where a control is set to Visible=No until a checkbox is
clicked then the control becomes visible.

That works. The obstacle is that it makes the control visible in all of the
records.

Only want the control visible in the records where the checkmark is True.

Any suggestions?

Thanks in Advance.

Andy.
 
The obstacle is that it makes the control visible in all of the
records.

Only want the control visible in the records where the checkmark is True.
Click to expand...

If you have A2000 or later, select the control in form design view and
select Format... Conditional Formatting. Use an expression checking
the checkbox to control the visibility (or color, or other properties)
of the control.

This feature isn't available in earlier versions.
 
Back
Top