How to show/hide columns in a query using a form checkbox?

[cykchanaa]

Currently I have a query where the criteria is dependent on the combo boxes on my form. I would like to add checkboxes to my form which determines which fields are shown or hidden. For example if I had a checkbox for address, selecting it on my form will show the address column in my query results. I am very new to access and have not been able to find a solution to a similar task online.

Any help would be greatly appreciated.

[June7]

Open a table or query and right click on any field header, from shortcut menu choose Hide or Unhide fields. Is this what you want to do programmatically? Not really practical with table or query.

The following code will hide table or query field that has the focus:
DoCmd.RunCommand acCmdHideColumns

The following example will hide a field of form in Datasheet view - it actually refers to a textbox name:
Forms!Games!tbxStartDate.ColumnHidden = True

https://msdn.microsoft.com/en-us/lib...ffice.11).aspx