Resize text boxes in Access Report

I have a report in Access 2013.  I need to have 8 text boxes resized based on the content in the fields in the underlying query for the report.  I have the can grow/can shrink properties in detail section in the report set to yes as well as the same properties set to yes for each control.  I have searched the solutions herein but have found none that work as yet.
HAC33Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

PatHartmanCommented:
What doesn't work? Post a picture of what you are seeing and tell us what is wrong with it.  The can Grow property only affects vertical growth.  It will not make boxes grow horizontally so you have to start them out at the maximum width they will ever have.  Certain types of grouping might make the boxes look better as they grow because all the boxes on a row will grow to the max size needed for any one of them.  Make sure that none of the controls in the section overlap.  Overlapping controls will keep shrink/grow from working correctly.
0
HAC33Author Commented:
PatHartman,

You have answered one part as I am not looking for vertical but only horizontal grow/shrink. No controls overlap.  I am trying to create an address block in a report and need to reduce the space between the names etc.  I have sample attached.
Also I did not see where to put points on my question.
Sample.accdb
0
PatHartmanCommented:
Your database can't be downloaded.  Have you looked at using columns for the report?
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

HAC33Author Commented:
Sorry, he database looks downloadable to me. It was created in Access 2013 and saved for 2007 and up and can't be saved for earlier versions.  I have not looked at columns.  What advantage are columns?
0
HAC33Author Commented:
PatHartmann,
I am attaching a picture of what the problem is.
0
PatHartmanCommented:
When I try to download it, I get an error that it can't be found.  I don't see a picture.

Columns make long lists shorter.  Think of how a phone book page used to look when we still used phone books.
0
HAC33Author Commented:
I am embedding the Sample db file Sample.accdb and pic Picture The attachments uploaded according to the message.
0
PatHartmanCommented:
Rather than put separate controls on the report, concatenate the fields into a single control.  Do this in the query.

Select LastName, FirstName & " " & LastName As FullName, Addr, City & ", " & State & " " & Zip as Addr2, ...
0
HAC33Author Commented:
Ok that makes sense, however, I am not sure how to do that in the query
0
PatHartmanCommented:
Open the recordSource query in design view, switch to SQL view for this exercise.  Use the syntax I posted previously.  Change the column names to match your own.  Then use the new FullName and Addr2 rather than the existing separate controls for all 5 parts.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
HAC33Author Commented:
Please take all the points for this solution!
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.