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.
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.