Creating A Dynamic Report Based On A Form

[ferrisj]

So I have a form that has a Multi select list box of one table. i want to be able to select the fields I want and then click the generate report button. The fields visible on the report would be different based upon which fields were selected on the report.

I thought it was some sort of IF statement in the field visible option in the report, but that only allows me to choose YES or NO.

 

[dhookom]

Are you sure you can't just create a few standard reports?

If you hide columns/fields/controls, would you expect the others to move left?

Do you really need a report or can you select fields and records and send the results to Excel for printing?

Duane
Hook'D on Access
MS Access MVP