Format report on execution

[Stoffman]

I am trying to setup a report whereby the user can select the fields they wish to see from the previous form. Does anyone know how I get Access reports to configure itself on execution. Without creating a report for ever conbination.

e.g. There are 5 fields displayed on the form each one has a checkbox next to it. The user selects the fields they want to see on the report by selecting some/Most or all of the checkboxes. Some magic happens possibly using visible field (yes/No) with can grow/Shrink properties and the report formats itself.

Anyone have any ideas?

 

[dhookom]

I would just create a dynamic query and push it out to Excel for the users to play with. There is a complete "applet" for doing this at

http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=12.

Duane
Hook'D on Access
MS Access MVP