Hide Field

J

jk

I have a main/subform that i would like to hide one of the fields in the
subform.I opened the properties of the field and placed visable as no but it
still appears.What would cause this not to work?
 
O

Ofer Cohen

It happen usually when the form view is in DataSheet View.

If that the case, run the form (not in design) and if it's a sub form then
run the form seperatly,
from the menu bar select Format > Hide column (for the column you want to
hide) close the form, you'll get a message if you want to save the form,
press yes.

Openning the form again wont display that field.
===============
Or, on the load event of the form run the code

Me.[FieldName].ColumnHidden = True
 
J

jk

Yes. I previosly did the format option and once the design on the form is
completed, i will have the form pop up from a switch board and hide the
tools. Will try the code since i am new to this and looking for best options.
Thanks alot for the support!

Ofer Cohen said:
It happen usually when the form view is in DataSheet View.

If that the case, run the form (not in design) and if it's a sub form then
run the form seperatly,
from the menu bar select Format > Hide column (for the column you want to
hide) close the form, you'll get a message if you want to save the form,
press yes.

Openning the form again wont display that field.
===============
Or, on the load event of the form run the code

Me.[FieldName].ColumnHidden = True

--
Good Luck
BS"D


jk said:
I have a main/subform that i would like to hide one of the fields in the
subform.I opened the properties of the field and placed visable as no but it
still appears.What would cause this not to work?
Click to expand...
Click to expand...
 
Top