field visibility

[Guest]

hi,

I would like for a field to be hidden in a record depending upon whether or
not there is a particular value in another field of the same record. I know
how to do this if the form is not in Continuous view. But the problem comes
where I have the form in continuous view. Does anyone know how to hide a
particular field of a record(s) depending upon the value of another field in
the same record?

Thanks in advance,
geebee

 

[John Welch]

You can use conditional formatting (format menu) to _disable_ a control
based on the value of another, but not make it invisible. I guess you use
this to set the background and font colors of the control (that is, textbox,
etc) to the same as the background of the form and also disable the control
to simulate invisibility.(By the way, in a form, the things you enter data
into are called controls. Fields are the columns in a table where the data
is stored, just to be clear). If you need to make it invisible, you can use
the current event of the form, if you are familiar with visual basic. Each
time the user selects a new record the current event fires and you can then
decide there whether or not to hide the control. If you do it this way, the
control will hide/show the same for all records, but that status will change
every time you select a different record.

hope this helps
-John

 

[fredg]

hi,

I would like for a field to be hidden in a record depending upon whether or
not there is a particular value in another field of the same record. I know
how to do this if the form is not in Continuous view. But the problem comes
where I have the form in continuous view. Does anyone know how to hide a
particular field of a record(s) depending upon the value of another field in
the same record?

Thanks in advance,
geebee

You can't hide a field in continuous view using it's Visible property.
What you can do is use Conditional Formatting of the control and set
it's ForeColor and BackColor of the control to the same value, i.e.
white.

 

[fredg]

You can't hide a field in continuous view using it's Visible property.
What you can do is use Conditional Formatting of the control and set
it's ForeColor and BackColor of the control to the same value, i.e.
white.

I clicked send too early.

Here is how to set the Conditional Format of a control based upon
another control's value.

Select the control you wish to not show.
Click on Format + Conditional Formatting
Set the Condition1 drop-down to
Expression Is
In the next box write:
[SomeOtherControl] = some value

Set the ForeColor to White
Set the BackColor to White
Save the changes.