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

pgilmour24

New member
Local time
Today, 11:23
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: 152

Minty

AWF VIP
Local time
Today, 11:23
Joined
Jul 26, 2013
Messages
10,354
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

Well-known member
Local time
Today, 07:23
Joined
Sep 8, 2020
Messages
1,090
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:23
Joined
Sep 12, 2006
Messages
15,613
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

..forever waiting... waiting for jellybean!
Local time
Today, 19:23
Joined
May 7, 2009
Messages
19,169
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:23
Joined
Sep 12, 2006
Messages
15,613
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

Super Moderator
Staff member
Local time
Today, 07:23
Joined
Feb 19, 2002
Messages
42,970
Try moving the box that grows so that it is at the bottom where it will not disturb you if it grows..
 

Users who are viewing this thread

Top Bottom