Simple Report Formatting Question

[Junior]

Good morning everyone.
I have what I think is a fairly simple question, with hopefully a
simple answer.

Question is regarding the "Can Grow" property.

The fields in the DETAILS section of my report contain borders. I
have the CAN GROW property set to Yes for all fields.

My question is - if one of the fields needs to grow to accomodate text
data, how can instruct the remaining fileds to also grow to the same
size. The right most field in my report contains user comments (it is
a memo field), and quite often it needs to grow, but the remaining
fields in the row do not grow. The result is that is looks messy -
becuase I have borders around the fields.

I want the report to have a "spreadsheet" feel to it, so I included
borders for each field to resemble "cells".

Any help would be appreciated.

GZ

 

[Allen Browne]

Simplest solution would be to add a line control to the bottom of the Detail
section, to give you the line between sections.

To get the vertical lines, use the Line method in the Page event of the
control. The code measures the distances in twips, where 1400 twips = 1
inch. You will need to decide how you want to space your lines, but this
example shows how to draw a red line the full height of the report:

Private Sub Report_Page()
Me.Line (Me.ScaleTop, Me.ScaleLeft)-(Me.ScaleTop, Me.ScaleHeight), vbRed
End Sub