Advice on report design. Psedo Ctrl array or hide show ctrl (1 Viewer)

gregs

New member
Local time
Today, 16:35
Joined
Aug 19, 2018
Messages
2
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

..forever waiting... waiting for jellybean!
Local time
Tomorrow, 05:35
Joined
May 7, 2009
Messages
19,169
what's with the boxes?
you can loop through your table and hide/unhide.
 

June7

AWF VIP
Local time
Today, 13:35
Joined
Mar 9, 2014
Messages
5,423
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_

Longboard on the internet
Local time
Today, 14:35
Joined
Sep 12, 2017
Messages
2,111
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?
 

Users who are viewing this thread

Top Bottom