Report fields shift down when long text box grows (1 Viewer)

pgilmour24

New member
Local time
Today, 11:12
Joined
Nov 25, 2020
Messages
9
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
Report 2.JPG
 

Attachments

  • Owl Lighting 3.zip
    497.3 KB · Views: 0

Minty

AWF VIP
Local time
Today, 11:12
Joined
Jul 26, 2013
Messages
8,014
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

Active member
Local time
Today, 06:12
Joined
Sep 8, 2020
Messages
664
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 :ROFLMAO:
 

gemma-the-husky

Super Moderator
Staff member
Local time
Today, 11:12
Joined
Sep 12, 2006
Messages
14,220
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

error reading drive A:
Local time
Today, 19:12
Joined
May 7, 2009
Messages
11,463
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

Super Moderator
Staff member
Local time
Today, 11:12
Joined
Sep 12, 2006
Messages
14,220
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.
 

Users who are viewing this thread

Top Bottom