Creating a visible field by record

[Guest]

I have the following code set up in a checkbox that will make a certain field
visible when required data is needed. When the checkbox is unchecked the
field is invisible. The problem I am having is that when I put a check in the
box it shows the field for all the records, not just the one I am working on.
And then when I exit out of the form and go back into it the field that
should be invisible is visible on all records. Is there a way to make this
specific to only records that have the check in the checkbox field?

If [Multi Shift] = True Then
[Operator2].Visible = True
Else
[Operator2].Visible = False
End If

 

[Guest]

You need to put that code also in the on current event of the form.

 

[Roger Carlson]

You could use Conditional Formatting to change both the background color and
the font color of a textbox to the same as the background color, but that
will still leave the control active for editing. Hmmmmm....

--
--Roger Carlson
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L

 

[Guest]

Thank you very much!

You need to put that code also in the on current event of the form.

I have the following code set up in a checkbox that will make a certain field
visible when required data is needed. When the checkbox is unchecked the
field is invisible. The problem I am having is that when I put a check in the
box it shows the field for all the records, not just the one I am working on.
And then when I exit out of the form and go back into it the field that
should be invisible is visible on all records. Is there a way to make this
specific to only records that have the check in the checkbox field?

If [Multi Shift] = True Then
[Operator2].Visible = True
Else
[Operator2].Visible = False
End If