Keep position of pictures and labels from changing on report 1

[bernie10]

Hi everyone,
I have a report that is generated from a form, and the text boxes on the report "can grow" depending on the amount of text entered in the form. The probelm is that when the text boxes "grow" it pushes other pictures and labels onto the next page of the report. Is there a way I can "hardcode" the position of the labels and pictures so they won't move even if the text boxes grow due to the input from the form?

Thanks,
Bernie

 

[dhookom]

I would try enlarge the text boxes in design view and then don't allow them to grow.

Duane
Hook'D on Access
MS Access MVP

 

[bernie10]

Problem is that I need them to be able to grow if there is a lot of text inputed; I just need the boxes to grow without affecting the other items (there is plenty of room).

My other idea was to programatically move the items back after the text boxes grow by coding in the picture and label's position. I have been unable to figure the correct event to use though- when I put the code in onload or onopen the code runs before the report is laid out.

Any other thoughts?

 

[dhookom]

You can't get the height of a grown control until the On Print event. It is then too late to set the picture or label position properties.

You might be able to use one or more subreports for your text boxes. Since I don't know much about your layout left to right and top to bottom, I can't be of much more assistance.

Duane
Hook'D on Access
MS Access MVP

 

[bernie10]

Subreport did the trick. Thanks again.