Box does not grow with txt fields

R

RoadKyng

Afternoon'

I have a report that has three stacked txt fields in the Detail section, all
with the 'can grow' attribute set to 'yes'. These fields are each on a line
by themselves. I have the following code on the 'On Print' event for the
Detail section:

Me.DrawWidth = 80

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

The problem is the box does not grow with the fields as it should. The
report prints task cards. Normally, there is room for (4) task cards per
page. However there are times when the fields are wuite lengthy and as little
as (1) task card can print per page. When this happens (1) box will print
with the test flowing through and below it.

What might I have wrong?
 
R

RoadKyng

I don't completely understand.
Are you saying I must determine the final height of the three text boxes
after they have grown and use this figure to set the final height of the text
box?
or
I have not properly set the height attribute of the text box?

I have not been able to find proper documentation on this method. I am using
Access 2003. Is it in the Help files or is there some other source?

Thanks for your time
 
R

RoadKyng

Marshall,
a follow-up.

when I look at the code line "Me.Line (0, 0)-Step(Me.Width,
Me.Section(0).Height), , B"

it appears to me to be saying 'draw a line starting at point 0,0 (X,Y axis)
and step (lengthen) it the final width and final height of the Detail section
of the report, whatever that ends up being'. By your response my
interpretation is incorrect. Can you enlighten?

The width is fine, it's the height that is the issue
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Rectangle Box 9
rectangle 2
Grow Vertical Line 11
2 out of 3 fields won't grow on report 4
How do I create Vertical line down whole detail section? 1
Box around sub Report 1
Can the header grow? 1
can grow text box 20

Top