[AccessD] Report grids

Steven, try this:

Set each control to Can grow, and remove any visible border (set to
transparent).
Tag each control with something such as "Colored"

Place the following code in your reports detail_format section:

Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
Dim ctl As Control
  Me.ScaleMode = 5
  For Each ctl In Me.Controls
    If ctl.Tag = "Colored" Then
        ctl.BackColor = Highlight
        Me.Line ((ctl.Left / 1440), 0)-((ctl.Left / 1440), 10)
        Me.Line (((ctl.Left + ctl.Width) / 1440), 0)-(((ctl.Left +
ctl.Width) / 1440), 10)
    End If
  Next ctl
Me.Detail.BackColor = Highlight
End Sub

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Steven W.
Erbach
Sent: Wednesday, July 30, 2003 3: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?

Steve Erbach
Scientific Marketing
Neenah, WI

"Eventually, socialists run out of other people's money." - Lady Margaret
Thatcher


_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com