Reports - Access 2007

[June7]

It is possible but requires tons of VBA code to modify the report in Design view to change the textboxes (add, remove, set ControlSource and position) then switch to Report or Print view (hopefully without having to save the modified report first). I don't recommend this approach. Don't recommend any procedure that routinely modifies db design and changing a query def is modifying design. I have only done something like this once and that was to allow users to customize export to Excel. Did not try to build a report. Suggest you identify the report arrangements most desired by users and build them and give users choice of reports to open.

[AlfBar]

Thank you June7

[June7]

Correction, I do have a procedure that modifies a report in design view then saves the modified report and reopens. I did this only because it seemed to make the report build faster. I know, weird. It's still a slow report but cut about 30 seconds from the process. The code sets properties of 7 graph objects.

AFAIK, this would not be possible if I want to make the db an accde.