Hide/Show Columns in MS Access Query using a Checkbox

Question

I am using MS Access 2016 and building a form to run a query that enables users to only extract columns that they need. I am planning on doing this with a checkbox for every column. How can I do this? I have tried the following but it does not work. It gives me a Compile Error: Method or data member not found.

Private Sub chk1_AfterUpdate()
  Me.column4.Visible = Nz(Me.chk1 = True, False)
End Sub

Private Sub Form_Current()
  Me.column4.Visible = Nz(Me.chk1 = True, False)
End Sub

This might be helpful: learn.microsoft.com/en-us/office/vba/api/… — bugdrown
– bugdrown, Commented Dec 28, 2021 at 3:42

Gustav · Accepted Answer · 2021-12-27 21:37:58Z

1

You can hide a control but not a field. So try, where TextBox4 is bound to your column4:

Private Sub chk1_AfterUpdate()
    Me!TextBox4.Visible = Nz(Me!chk1.Value, False)
End Sub

Private Sub Form_Current()
    Me!TextBox4.Visible = Nz(Me!chk1.Value, False)
End Sub

answered Dec 27, 2021 at 21:37

Gustav

56.5k7 gold badges33 silver badges65 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Sola Oshinowo · Accepted Answer · 2021-12-27 21:56:10Z

0

  Private Sub Check20_Click()
         If Me.Check20.Value = -1 Then
         Me.ID.Visible = False
         Else
         Me.ID.Visible = True
         End If
   End Sub

i will advise you to be careful placing any code under the form_current event, because it might be tricky to implement, this approach

answered Dec 27, 2021 at 21:56

Sola Oshinowo

6297 silver badges17 bronze badges

1 Comment

Mansoor Over a year ago

Thank you but this code still gives me the same error: Method or data member not found

Collectives™ on Stack Overflow

Hide/Show Columns in MS Access Query using a Checkbox

2 Answers 2

Comments

i will advise you to be careful placing any code under the form_current event, because it might be tricky to implement, this approach

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

i will advise you to be careful placing any code under the form_current event, because it might be tricky to implement, this approach

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related