Basic Report Question

  • Thread starter Thread starter Dave
  • Start date Start date
D

Dave

I have a form full of check boxes for things like first
name, last name, address, etc. I want the user to be
able to check all the boxes they would like to view in a
report. Can I do this, and if so, how? Please help!!!
 
Yes, you can. And there are a couple of ways you can
incorporate this into your Report.

One way is:

In your report, place the following fields into your
detail section: first name, last name, address, etc

Then you will need to add the following code to the
Detail_Print event:

With Me
.FirstName.Visible = Forms![MyForm]![chkFirstName]
.LastName.Visible = Forms![MyForm]![chkLastName]
.Address.Visible = Forms![MyForm]![chkAddress]
<< and so on... >>
End With

As I've described above, it should give you a start in
terms of doing other things with it.
 
Back
Top