Visible property in subform columns

[MDB]

Hi All,

I have a form which is made up of a few fields and a subform. When I set the visible property to NO for either of the fields in the subform the columns are still visible.

However, when I set the visible property to No in te master form the fields are hidden.



Many thanks.

[ajetrumpet]

you are probably thinking of "column" as something other than the field. the discrepency, as hence the issue, probably lies there.

[boblarson]

To set a subform's column (in datasheet view) to hidden:

From the parent form:

Me.SubformControlNameHere.Form.ControlNameHere.ColumnHidden = True

Where SubformControlNameHere is the name of the subform control (control on the parent form which houses the subform) and not the name of the subform itself, unless they are exactly the same name.

From the subform itself the code is:

Me.ControlNameHere.ColumnHidden = True

See this reference for what you can do with datasheets:
http://msdn.microsoft.com/en-us/libr...ffice.11).aspx

[MDB]

Hi Bob,

Thanks for your informative and constructive response. This has worked.

To set a subform's column (in datasheet view) to hidden:

From the parent form:

Me.SubformControlNameHere.Form.ControlNameHere.ColumnHidden = True

Where SubformControlNameHere is the name of the subform control (control on the parent form which houses the subform) and not the name of the subform itself, unless they are exactly the same name.

From the subform itself the code is:

Me.ControlNameHere.ColumnHidden = True

See this reference for what you can do with datasheets:
http://msdn.microsoft.com/en-us/libr...ffice.11).aspx