Hide/Show field using checkbox (1 Viewer)

jabaker54

Registered User.
Local time
Today, 08:50
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.
 

smig

Registered User.
Local time
Today, 18:50
Joined
Nov 25, 2009
Messages
2,209
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

Top Bottom