Creating section blocks

[Tangier]

Hi,

I want to design a report that has nine contiguous boxes with data in
them.

When designing the report, I want to create sections of the report,
instead of having all these individual boxes for extensibility
purposes. In other words, when the report changes and I need to change
or add items to the report, I want to be able to efficiently move
these nine boxes, as one whole section, instead of reorganizing nine
boxes all over again.

I can easily do this in Microsoft Reporting Services, however, I need
to use Access for cost purposes!

I tried to create a section in the report using the help menu
instructions, however, I did not see a menu item, "Add Section" in the
menu bar under "Insert", like the Help Menu suggested.

Can anyone help? I am using Access 2002

 

[Duane Hookom]

Sections are added using the Sorting and Grouping dialog. If you want to
create a new "detail" section, you can create a new lowest level in the
Sorting and Grouping dialog and set its Field/Expression to the primary key
value of your report's record source. Display either the header or footer for
this level.

 

[Marshall Barton]

I want to design a report that has nine contiguous boxes with data in
them.

When designing the report, I want to create sections of the report,
instead of having all these individual boxes for extensibility
purposes. In other words, when the report changes and I need to change
or add items to the report, I want to be able to efficiently move
these nine boxes, as one whole section, instead of reorganizing nine
boxes all over again.

I can easily do this in Microsoft Reporting Services, however, I need
to use Access for cost purposes!

I tried to create a section in the report using the help menu
instructions, however, I did not see a menu item, "Add Section" in the
menu bar under "Insert", like the Help Menu suggested.

Can anyone help? I am using Access 2002

We call that "grouping" controls, but, despite many pleas
for that capabiliy, it sitll doesn't exist in Access.

OTOH, you can just drag a selection rectangle around a bunch
of controls and then drag all of them at once.

 

[Marshall Barton]

Please keep the correspondence in the news groups. Private
email is reserved for paying clients.

To select multiple controls in a "block", press the left
mouse button in a blank area of the report section next to a
control in a corner of your "block". Then drag the mouse to
the diagonal corner of your "block" and release the mouse
button.

That will select all the control in the retangular area and
you can then move them all at once.

If your controls are not arranged in a single rectangular
area, then you can hold the shift key down and select
multiple rectangular areas and/or individule controls.
Release the shift key before trying to move the collection
of selected contols.