Hide/Show field using checkbox

jabaker54

Registered User.
Local time
, 17:31
Joined
Jul 30, 2014
Messages
11
Hello all,

I have a sub form with checkboxes. Each check box represents one of the columns/fields in my query. If one of the boxes is checked, I only want the column that matches with the check box to appear.

I have done some research and have came upon the ColumnHidden property.

How would one do this in a macro or VBA format.
 
Me.FieldName.Visible = false/true
Not sure if this will work for spreadsheet look, though. If its not try the.columnhidden
 

Users who are viewing this thread

Back
Top Bottom