Hiding controls on continuous forms

  • Thread starter Thread starter Luke Bellamy
  • Start date Start date
L

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
 
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
 
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,
 
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.
 
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.
 
Back
Top