How do you word wrap a text/label field in a Microsoft Access 2007 form

How do you word wrap a text/label field in a Microsoft Access 2007 form
wademiAsked:
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.

Rey Obrero (Capricorn1)Commented:
you have to make the label width narrow
0
Rey Obrero (Capricorn1)Commented:
you have to make the label width narrow and tall
0
wademiAuthor Commented:
I made the label narrow and tall by using my mouse to adjust it. that didnt work
0
The Ultimate Tool Kit for Technolgy Solution Provi

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 for valuable how-to assets including sample agreements, checklists, flowcharts, and more!

wademiAuthor Commented:
Parts of the labels and text are still hidden
0
Rey Obrero (Capricorn1)Commented:
then resize the label or set the font to a smaller value
0
Andrew_WebsterCommented:
For a label, type in its contents, then resize it by selecting it with the mouse, and drag the handles.  If it's about right already, double-click the handles and it will resize to a "best guess" size that fits your text.

If you want to resize a text box that will contain data, you'll have to do so manually in design view.  If you expect there to be more text that might be visible, then you can set the  Scroll Bars property (on the Format tab of the text box properties window).

If you want to resize it dynamically at runtime, then there is no automatic way to do that.  In fact it's a major task to write VBA that is capable of detecting the size of your text automatically, so I'd avoid trying unless you want to become a full-time guru developer.
0
wademiAuthor Commented:
My labels are just not resizing. is there an option to turn on word wrapping?
0
Rey Obrero (Capricorn1)Commented:
<is there an option to turn on word wrapping?> NONE

My labels are just not resizing..
you may have to ungroup the textboxes and labels first
0
Andrew_WebsterCommented:
If this is Access 2007, then Capricorn1's last comment is spot on.  Access 2007 gets all "helpful" when it automatically lays out a form, and groups controls so that their layout can't be changed individually.

(Hi, capricorn1, btw!)
0
wademiAuthor Commented:
The llabels are not grouped. Arrange - Romve option is grayed out when the label is selected
0
Rey Obrero (Capricorn1)Commented:
can you upload your db
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
wademiAuthor Commented:
I cant. Its against company policy
0
bnbhooverCommented:
you can "wrap" the text inside the label manually by selecting where you'd like the line break to go and typing ctrl-enter.
1
Andrew_WebsterCommented:
wademi: can you take a screenshot of the form in design mode and upload that?  Try and get the properties window in the shot.
0
Rey Obrero (Capricorn1)Commented:
that will work, but you have to resize the label first..
0
Rey Obrero (Capricorn1)Commented:


check also if the Arrange > Ungroup is also grayed.
0
Member_2_7967346Commented:
BNBHoover's response "you can "wrap" the text inside the label manually by selecting where you'd like the line break to go and typing ctrl-enter." works a treat in word-wrapping labels in Access 2007 forms.
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.