Inserting grids or tables into reports

[Adam]

Hi All,

I've got to make a report which breaks down measures we've taken for
260 retailers.

I did this report last time by making a mail merge into Word from data
held in an excel spreadsheet. The data just populated tables that I put
into the word document.

I'm not trying this exercise through Access and combining the data
stored in tables and presenting them in the Report.

The trouble is I'm using Text Boxes and am stacking them on top of each
other to make a table.

Is there anyway that I can insert a grid or table into a Report?

This would help me a lot !

Many Thanks
Adam

 

[Douglas J. Steele]

All you should need to do is ensure that the text boxes are all properly
aligned, and ensure that you've set the border style for the text boxes
appropriately.

 

[Adam]

Its such a pain though! I have to carefully place around 30 text boxes
and I swear they move around by themselves!

 

[Douglas J. Steele]

Select a number of text boxes at once (either by holding down the shift key
and clicking on the controls you want to select, or by putting the cursor in
the ruler to the top or left of the report, which will select everything in
that column or row)

You can now ensure that they all line up under the Format menu (Align | Left
and Align | Top). As well, whatever you type in the Property sheet will
apply to all of the controls at once, so you can ensure that they all have
the same height and width.

Yes, it's a little fussy, but you don't have to do it that often...

Another alternative is to do it in code (on the report's Open event, say).
You can programmatically set the Left, Top, Height and Width properties for
the text boxes. Just remember that you specify them in twips (there are 1440
twips to the inch, so if you wanted a particular text box to be half an inch
from the left, you'd set its Left property to 720)