Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Make checkbox invisible in continuous forms individually

3 views
Skip to first unread message

Mesa

unread,
Feb 5, 2007, 7:22:02 AM2/5/07
to
I looked all over for this but was unable to find the answer. Im
trying to make a checkbox on a continuous form visible if there is a
value in another textbox per record. On continuous form view it
changes the checkbox visibility of all records, otherwise my coding
works fine in single form.

Allen Browne

unread,
Feb 5, 2007, 7:50:13 AM2/5/07
to
You cannot conditionally hide/show controls on a continuous form.

The nearest you can do is to use a text box so you can apply conditional
formatting. This will allow you to use white-on-white or some such
arrangement that makes the box appear to disappear.

For details on how to make a text box that looks like that, see:
Format Check boxes on reports
at:
http://allenbrowne.com/ser-52.html

If you intend the user to be able to click the check box, you will need to
place a real text box on the form behind the text box, and use the GotFocus
event of the text box to SetFocus to the check box.

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Mesa" <sworn...@gmail.com> wrote in message
news:1170678122.5...@h3g2000cwc.googlegroups.com...

0 new messages