Access 2010 Hide/Show Fields In Subform Button

[accote]

Hi Everyone, and thanks for any help you can provide.

I have a main form with a datasheet subform, I know I can hide/unhide columns by right clicking
on the columns in the subform, but would prefer to have a button on my main form that will do just


that. How can I create a button that when clicked in the header of the main form will give me the
options to hide or unhide available columns in the subform?

Thanks

accote

[June7]

I tried this with subform in Datasheet view, didn't work, Continuous view does work.

Options:

1. checkbox
Me.subformname.Form.textboxname.Visible = Me.checkbox

2. command button (or maybe a toggle button)
Me.subformname.Form.textboxname.Visible = Not Me.subformname.textboxname.Visible

Also, textbox cannot have focus.

[accote]

Hi June7, thanks for the input, but I can't change it to continuous view as there is a one to many
relationship between the 2 tables the forms get their value from.
The Main form is a Single Form and the Sub form only shows correctly in Datasheet view.
Thanks for trying.

accote

[June7]

The subform can still be Single or Continuous view. Controls in Continuous view can be arranged to appear as Datasheet. If the controls are grouped in a Layout, select all and right click Layout>Remove. Then the controls can be moved and resized as desired.