Hidding fields in form

[John8359 via AccessMonster.com]

Hi every one

I am not very familier in access and here is my problem.
I have a form where i need to hide some fields when one fields content is
selected.what formula will i use and also will that formula be under the
field that i want to hide or the form it self?

Can any one help please?

 

[Guest]

I believe FieldName.visible = True or False will make the field visible and
invisible.

Depending on your needs you may want to make the field INVISIBLE or VISIBLE
on the OPEN and/or CURRENT Event and then turn it either on or off based on
what is in or not in the field your testing.

If Field1 > 1 then
FieldName.visible = True
else
FieldName.visible = False
end if

You may also need to play around with your Tab stops when you make the field
visible so it will stop there and turn them off when the field is invisible.

Hope this helps.

 

[John8359 via AccessMonster.com]

Thanks I will try it out.

I believe FieldName.visible = True or False will make the field visible and
invisible.

Depending on your needs you may want to make the field INVISIBLE or VISIBLE
on the OPEN and/or CURRENT Event and then turn it either on or off based on
what is in or not in the field your testing.

If Field1 > 1 then
FieldName.visible = True
else
FieldName.visible = False
end if

You may also need to play around with your Tab stops when you make the field
visible so it will stop there and turn them off when the field is invisible.

Hope this helps.

Hi every one

[quoted text clipped - 4 lines]

Can any one help please?