[AccessD] Report grids

Arthur Fuller artful at rogers.com
Wed Jul 30 23:15:26 CDT 2003


You seem to have changed the subject midway from reports to forms. Assuming
that you want to do a report, why not do a Word-automation document with all
the tables in place formatted just so and bookmarks in them to splat the
data into the appropriate columns. I have done this and it's a little
tedious but not difficult.

Arthur

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Steven W. Erbach
Sent: July 30, 2003 6:37 PM
To: AccessD at databaseadvisors.com
Subject: [AccessD] Report grids


Dear Group,

I've never tried this before and I can't figure out how to do it.

A customer of mine wants a report that looks similar to a Word document. The
Word document is laid out in several sections, each section contains a Word
table. One column in each of the tables contains a comment, and the cell
containing the comment expands as more text is entered. The row containing
that comment gets taller automagically as more text is typed.

I can't seem to find a way to place a "grid" of fields on a report that has
the same type of characteristic; that is, that all the cells in a row will
increase in height to match the tallest cell. I can, of course, draw boxes
around each individual text box; but only the comment text box grows in a
particular row. The rest of the text boxes in that row don't grow along with
the comment.

A continuous form design wouldn't do the trick because the text boxes still
don't grow as tall as the tallest one when the report is previewed or
printed. It's also devilishly tricky to make a "grid" of text boxes so that
the vertical sides of the text boxes line up exactly with the column
headings.

Is there anything like a "table" in Word that can be used in Access?




More information about the AccessD mailing list