Fields showing in report based on form criteria

[ITguy1981]

I understand how to make a report base on a query. I typically create a form to enter the criteria in to the query and open the report from a button on the form. However, sometimes I would like to keep some fields out of a report. So, for instance if I have a table for example with the fields: name, address, age, sex, etc and I have a report that reports all of the fields of the table, I would like to be able to use my form that enters the query criteria for the fields and possibly have tick boxes beside each field on the criteria entry form so you can choose which fields show on the repot. So if I only want to report names and ages I could enter "john" in the name box on the form and check the box beside it and possibly leave ages blank and check the box beside it so my report only show people named John along with their ages. Am I making sense? I was thinking this would be way better than creating a report for every possible search option you would want to do for the specific table.

 

[vbaInet]

This isn't an easy task. If you have three controls, Textbox 1, Textbox 2, Textbox 3 and Textbox 4, and you hide Textbox 2. There will be a gap between Textbox 1 and Textbox 3 right? How do you circumvent this? Write code to move Textboxes 3 and 4 to the left. But what if you have a Line control stretching the entire length of the report, controls that are to the right of your report ... etc.

You will struggle to get the layout right because it requires expert coding.

This is the kind of feature that you'll find in Report Creation modules.