Visible= Yes/No

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


"Andy" wrote in message
...
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.

Rick;

Thank You.

Andy

"Rick B" wrote in message
...
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


"Andy" wrote in message
...
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.

On Tue, 8 Jun 2004 10:24:35 -0400, "Andy"
wrote:

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.

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.

John W. Vinson[MVP]
Come for live chats every Tuesday and Thursday
http://go.compuserve.com/msdevapps?loc=us&access=public