Dynamic text boxes in a report... (1 Viewer)

[hirsp1]

Is is possible to create a text box dynamically based on table/query data? For instance, if I would like to loop 52 times (one for each week) and generate text based on the value of a query to put in the text box....create [Week01] with specific properties (height, width, background color, forecolor, control source the result of a function, etc), [Week02], [Week03],...[WeekX]

Does this make sense? Right now, I have 52 text boxes and have a function that jumps through hoops to determine what goes in the box. If I can dynamically generate the text boxes, I can more easily determine how the box gets filled...or change the number of boxes without reformatting the report.

 

[Pat Hartman]

There is an example of a report based on a crosstab that creates fields on the fly. You can find it in solutions.mdb which should be installed on your computer if you installed the samples when you installed Access.