Field View when checkmark in checkbox

[Chip1035]

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.

 

[fredg]

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.

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

 

[Chip1035]

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...

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.

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

 

[Chip1035]

Anyone?

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...

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.

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