Wrapping text in a text box in Access

Posted on 2009-02-18
Last Modified: 2013-11-28
I have an Access 2007 report that contains a text box that the user types a title into.  Is there a way to make the text wrap in this box or do i have to make the box huge in case i need the space?
Question by:barnescs
    LVL 84

    Accepted Solution

    Set the CanGrow property to Yes.

    <I have an Access 2007 report that contains a text box that the user types a title into.>

    Users enter data in a Report? That's odd ...

    Author Comment

    No, the users don't type into the report.  I was thinking ahead of myself.  they enter their information into a form and then a query runs off the table created by the form and creates the report.

    I changed the Can Grow to "yes" and re-ran the report.  It looks GREAT.


    Featured Post

    Gigs: Get Your Project Delivered by an Expert

    Select from freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely and get projects done right.

    Join & Write a Comment

    Suggested Solutions

    In the article entitled Working with Objects – Part 1 (, you learned the basics of working with objects, properties, methods, and events. In Work…
    In Debugging – Part 1, you learned the basics of the debugging process. You learned how to avoid bugs, as well as how to utilize the Immediate window in the debugging process. This article takes things to the next level by showing you how you can us…
    In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …
    With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

    734 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    21 Experts available now in Live!

    Get 1:1 Help Now