Hide a Column in a Subform - Microsoft Access Forum


	Back to Access Forum Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

Hide a Column in a Subform

Brian Crawford

4 years ago

I have a form based on a query that has many columns that are displayed in a Subform with a Data Sheet view. Three of these subform columns are orgL1, OrgL2, and OrgL3 that represent the 3 levels of the org structure, which also have long text values.

To save space, I would like have a button on the main form to toggle hiding or displaying these columns. I am not sure how to reference these fields on the subform from the main form so that I can set the .Visible property to False or True (Assuming that is the correct way to do this).

	Brian Crawford OP @Reply 4 years ago
I see that the property I need to change is .orgL1.ColumnHidden=True, but I still don't understand how to reference the orgL1 field on the subform from the main form.

	Kevin Robertson @Reply 4 years ago
Try this, replacing with the name of your Parent Form, Subform and Field as appropriate. `With Forms!ParentFormName!SubformName.Form!FieldName If .ColumnHidden = True Then .ColumnHidden = False Else .ColumnHidden = True End If End With` See Value From A Form

	Brian Crawford OP @Reply 4 years ago
Thanks Kevin! When switching between languages, it's the syntax that always trips me up. Because the property is boolean, the toggle could just be the NOT of its current value: With Forms!ParentFormName!SubformName.Form!FieldName .ColumnHidden = Not .ColumnHidden End With

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Forum.

Next Unseen

New Feature: Comment Live View