Report fields shift down when long text box grows

[pgilmour24]

Hi all,
I am using my database to create product sheets for a lighting design company. Each product is bespoke and descriptions obviously change. I have created a report for a downlight and I am happy with the layout, but when I open the report in print preview mode, half of the fields have shifted down in line with one of the long description boxes which has expanded - see photos for what I mean!

I have also uploaded the zip file of the database.
Any help would be greatly appreciated!
Thanks
Peggy

 

[Ranman256]

Turn off propery CAN GROW

 

[pgilmour24]

Turn off propery CAN GROW

Thanks but I need that box to grow as there will be more information on some

 

[Minty]

You will have to do a fair amount of messing around in VBA to get this to all line up really nicely.
You can get the height of the largest possible box, then adjust the size of the other smaller controls hieghts to match.

It's a bit of a long-winded method but means you get nicely aligned reports.

 

[tmyers]

As a person who's primary job is to read these spec sheets for lighting fixtures, I hope the experts here can get it working for both our sakes

 

[gemma-the-husky]

It's tricky, because I presume you have data in columns, and the columns are independent.
Maybe Stephen Lebans had some ideas to manage this sort of thing. Worth looking.

Lebans.com

 

[arnelgp]

as advised, turn Can Grow = No.
now make the textbox High and Wide enough
to accommodate the largest text.

or make the height and width fix, and
adjust the Font size when there is much
text.

 

[gemma-the-husky]

as advised, turn Can Grow = No.
now make the textbox High and Wide enough
to accommodate the largest text.

or make the height and width fix, and
adjust the Font size when there is much
text.

Yes. Stephen Lebans had a fix for changing the font size, but it's a bit hard to read if it goes much below say 4 or 6.

 

[Pat Hartman]

Try moving the box that grows so that it is at the bottom where it will not disturb you if it grows..