Visible property

[David]

An earlier posting regarding the same subject was
answered but the solution was somewhat out of my
[beginners] league. I apologize for the redundancy.

Is it (and it must be) possible to turn on and off the
Visible property of controls and labels depending on the
value of another field in the record. I'm guessing the
expression would be something like:
[Disappearing Field].Visible IIf([Field]
=IsNull,"Yes","No")

...but I'm not sure where this would go in the form.

Thanks for your patience.

 

[Hugh O'Neill]

Tell me exactly what the items are. Text boxes or whatever. Give me
the 2 names and I will show you how.

me.textbox1.text.visible = false

if me.textboxbox1.text is empty then
me.textbox1.text.visible=true

An earlier posting regarding the same subject was
answered but the solution was somewhat out of my
[beginners] league. I apologize for the redundancy.

Is it (and it must be) possible to turn on and off the
Visible property of controls and labels depending on the
value of another field in the record. I'm guessing the
expression would be something like:
[Disappearing Field].Visible IIf([Field]
=IsNull,"Yes","No")

..but I'm not sure where this would go in the form.

Thanks for your patience.

Mike, just a reminder that unlike VB, in Access VBA the .text is not
necessary and in any case is only valid when the control has the focus.
In Access VBA, use .value instead. In fact, since that is the default,
you don't need to specify it at all and the control's value can be
retrieved anytime - it does not need to have focus.

hth

Hugh

 

[David]

Hi,

A bound control called [Location] determines whether a
subform called [Individual Subform] is displayed or not.
If the value for [Location]="Racer", then the subform is
seen, otherwise, it is hidden.

There are a few other things that I would like acting the
same way but I'm guessing it would be a matter of copy,
paste and change.

Where would the statement be entered?

David

-----Original Message-----
Tell me exactly what the items are. Text boxes or whatever. Give me the 2
names and I will show you how.

me.textbox1.text.visible = false

if me.textboxbox1.text is empty then
me.textbox1.text.visible=true

An earlier posting regarding the same subject was
answered but the solution was somewhat out of my
[beginners] league. I apologize for the redundancy.

Is it (and it must be) possible to turn on and off the
Visible property of controls and labels depending on the
value of another field in the record. I'm guessing the
expression would be something like:
[Disappearing Field].Visible IIf([Field]
=IsNull,"Yes","No")

..but I'm not sure where this would go in the form.

Thanks for your patience.

.