Results 1 to 2 of 2
  1. #1
    grant.smalley is offline Novice
    Windows Vista Access 2000
    Join Date
    Jan 2010

    Auto expand memo field vertically to fit text


    I have a sub form (Tabular) and users add notes in a memo field called 'Notes'. I would like the memo field to expand vertically to fit the text to make it easier for users to view the notes in one go without having to scroll or zoom from each seperate memo field.

    To give you a rough idea of the size, the memo field should fit approx 50 characters before wrapping to the next line.

    Any help would be much appreciated.

    Kind regards,


  2. #2
    NassauBob's Avatar
    NassauBob is offline Not THAT Green
    Windows XP Access 2003
    Join Date
    Feb 2010
    Augusta, GA
    Maybe try setting the object's width, and the CanGrow to Yes or 1 in the property sheet...

Please reply to this thread with any new information or opinions.

Similar Threads

  1. How to vertically align text inside a text box ?
    By alexcalgary in forum Forms
    Replies: 2
    Last Post: 10-06-2010, 08:44 AM
  2. Expand field horizontally
    By jonsuns7 in forum Reports
    Replies: 1
    Last Post: 10-15-2009, 04:54 AM
  3. MEMO field
    By casporov in forum Access
    Replies: 1
    Last Post: 11-11-2006, 08:17 PM
  4. Replies: 9
    Last Post: 07-21-2006, 05:17 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
Other Forums: Microsoft Office Forums