Advice on report design. Psedo Ctrl array or hide show ctrl

[gregs]

I have a report I want to do where rows and columns of boxes will vary. Not sure if I should just put all the boxes on the report and hide them, then loop through my table and make the ones I want visible. Any thoughts on best way to do this?

will be 13-16 rows and 2-10 columns.
1. [] [] [] [] [] []
2. [] [] [] [] [] [] [] []
... and so on

 

[arnelgp]

what's with the boxes?
you can loop through your table and hide/unhide.

 

[June7]

How can you 'loop through table'?

These 'rows' are records? These are textboxes with [ ] characters? You can have a conditional statement in the ControlSource. What is the criteria for display of text?

 

[Mark_]

Put the boxes on the report and hide/unhide as needed.
Trying to create controls can cause issues because ACCESS limits the total number of controls that could ever be in a procedure. If you were to try creating them at run time, you are setting yourself up for issues.

If you have multiple rows, does that mean one row per record? How many total boxes are you thinking?

Also, is this something that could be done with a graphic that is swapped depending on need?