Can Grow property

[skydiver]

I know when you set the Can Grow property of a text field, the field will
grow causing the record to expand, when there is much data for the default
setting of the text box.

Is it possible to make the other fields in each record expand to the same
height as the largest field of that record? If you don't have borders
around the fields it is not a problem, but if you was to make the report
look like a table in a Word document by aligning the text boxes and putting
a border around them, the fields are not the same size.

Not putting borders around the text boxes and using a horizontal line looks
neat and clean. I was trying to make the report look like a hard copy
document I was given.

Thanks in advance.

 

[Jeff Boyce]

Perhaps another option would be to use Word. That is, use a query to get
the data you want, then export it to Word for your more formal formatting
requirements...

JOPO (just one person's opinion)

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[KARL DEWEY]

Try putting all on the same level (horizontal row) at the same Top property
setting. Then make sure any that are further down the page have their Top
set to greater than the Top above plus it's height do it will always be lower.

 

[Marshall Barton]

I know when you set the Can Grow property of a text field, the field will
grow causing the record to expand, when there is much data for the default
setting of the text box.

Is it possible to make the other fields in each record expand to the same
height as the largest field of that record? If you don't have borders
around the fields it is not a problem, but if you was to make the report
look like a table in a Word document by aligning the text boxes and putting
a border around them, the fields are not the same size.

Not putting borders around the text boxes and using a horizontal line looks
neat and clean. I was trying to make the report look like a hard copy
document I was given.

Don't use borders. Instead, draw the boxes using the Line
method in the Print event. For example, add a line of code
for each text box:

Me.Line (text1.Left,0) - Step(text1.Width,Me.Height),,B

 

[skydiver]

Thanks for your response Mr. Barton. That worked great. Is there anyway to
change the width of the line from hairline to 1 point when it prints out?

I had the line set to 1 pt, but where the line expanded past the default
length, the width drop back to the default hairline width.

Thank you for your time.

 

[Marshall Barton]

Set all of the text box's BorderStyle to Transparent.

You can specify the line width by using the DrawWidth method
before drawing the boxes

Me.DrawWidth = 3