Field View when checkmark in checkbox

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Chip1035 - 10 Mar 2005 16:59 GMT

I am not a master, professional or even an ametuer in Access. I hope I will
be clear in what I am trying to accomplish. Here it goes...

I have a form with a checkbox to state a true value. When the checkmark is
placed, I want the specific field to be viewable, if the checkbox is clear,
the field to be invisable.

Little clearer, example:
I have a database of employees and their computer systems. I want to show
if the user has a printer or not via the checkbox. If the user does have a
printer, place a check in the checkbox and the printer name becomes visable.
If the user does not have a printer, the checkbox is left unchecked and the
printer name does not show.

Basically, it is like an "IF" statement in Excel, If checkbox is yes, view
printer name, otherwise do not view printer name.

I already have it setup where the printer name is visable no matter if the
user does or doesn't have a printer.

Signature

-Chip
=)

Reply to this Message

fredg - 10 Mar 2005 18:19 GMT

> I am not a master, professional or even an ametuer in Access. I hope I will
> be clear in what I am trying to accomplish. Here it goes...
[quoted text clipped - 15 lines]
> I already have it setup where the printer name is visable no matter if the
> user does or doesn't have a printer.

The check box should be bound to a field in the table.

Code the check box AfterUpdate event as well as the Form's Current
event:

[PrinterControl].Visible = Me![CheckBoxName] = -1

Signature

Fred
Please only reply to this newsgroup.
I do not reply to personal email.

Reply to this Message

Chip1035 - 10 Mar 2005 19:05 GMT

Great! It works but with one catch...

If I am viewing the data and one record does not have a check, printer name
is not there, when I view a record with the box checked, the printer name is
not there. If I click the checkbox to remove the check, then recheck it to
put the check back, the printer name comes up but if I view the record
without a check, printer name is visable.

> > I am not a master, professional or even an ametuer in Access. I hope I will
> > be clear in what I am trying to accomplish. Here it goes...
[quoted text clipped - 22 lines]
>
> [PrinterControl].Visible = Me![CheckBoxName] = -1

Reply to this Message

Chip1035 - 17 Mar 2005 18:49 GMT

Anyone?

> Great! It works but with one catch...
>
[quoted text clipped - 30 lines]
> >
> > [PrinterControl].Visible = Me![CheckBoxName] = -1

Reply to this Message