Hiding controls on continuous forms

[Luke Bellamy]

Hi,
Just wondering if there is a way to selectively hide/show controls
on a continuous form? What I mean by this is that I have a check box
on a continuous form but I would only like to show it under certain
conditions
for each row.
So I was hoping somewhere using VBA I could set the checkbox visible
property to true or false. At the moment when I do it, it hides or shows
the checkbox on every row.

Using A2K.

Thankyou

 

[Steve Schapel]

Luke,

No, this is not possible with normal Access functionality. Using
Conditional Formatting of the checkbox, you can control whether it is
Enabled or not, depending on the criteria, but this does not apply to
the Visible property.

- Steve Schapel, Microsoft Access MVP

 

[Luke Bellamy]

Thanks Steve.
Do you have an example of setting the checkbox
enabled property as you said? If I can work out the
principal of how conditional formatting is done for
continuous forms maybe I can brainstorm a different
way to do what I need.

Thanks again,

 

[Steve Schapel]

Luke,

Select the checkbox in the design view of the form, and then select
Conditional Formatting from the Format menu. Please post back if you
need any further help with this.

An additional idea or two are available from
http://www.lebans.com/conditionalformatting.htm

- Steve Schapel, Microsoft Access MVP

 

[Stephen Lebans]

As long as you can live without a Border, you can use CF to set the
BackColor, Forecolor Enabled props to effectively hide the control.
Backcolor and Forecolor to match background of Form, Enabled = False.

--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.

 

[Steve Schapel]

Ahem, it's a checkbox, Stephen.

- Steve Schapel, Microsoft Access MVP

 

[Stephen Lebans]

I did not see that in the original post. In the sample CF MDB you
pointed the OP to is a FOrm showing how to use a TextBox to simulate a
COmmandBUtton. YOu could modify it to simulate a checkbox by using the
proper FOnt that contains a Check mark sysmbol. THere's always a
way!<grin>

--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.

 

[Luke Bellamy]

Thanks alots Steve's
I should just make the Lebans web site my
home page