[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 4575
  • Last Modified:

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
0
wademi
Asked:
wademi
  • 7
  • 5
  • 3
  • +2
1 Solution
 
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 new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

 
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
 
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

Featured Post

Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

  • 7
  • 5
  • 3
  • +2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now