Results 1 to 4 of 4
  1. #1
    mnsemple83 is offline Advanced Beginner
    Windows 7 32bit Access 2007
    Join Date
    Jul 2011
    Posts
    40

    Drop-Down list to display remaining text.

    I am working on a form that consists of two fields: "Date" and "Notes". The "Date" field is of type "Date/Time" while the "Note" is of type "Text". What I want to do is modify the "Note" field so that when a user types several rows of text, then saves the form, when they want to view what they wrote, they will only be able to view one line of what they typed. To review the rest, they would have to click on a button representing a drop-down list that will contain the remaining text. Can this be accomplished using a macro or would it require VBA code?

  2. #2
    rpeare is offline VIP
    Windows XP Access 2003
    Join Date
    Jul 2011
    Posts
    5,442
    Is it possible for you to set the CAN GROW property of your field to YES. This will automatically expand the box to show all the text the person typed in.

    Note: you can also use

    FIELDNAME.SelStart = 0

    This takes your cursor to the first position of a text box then you can just use your down arrow to scroll through the field

  3. #3
    mnsemple83 is offline Advanced Beginner
    Windows 7 32bit Access 2007
    Join Date
    Jul 2011
    Posts
    40
    Is there also a way for me to wrap the text in a text box?

  4. #4
    rpeare is offline VIP
    Windows XP Access 2003
    Join Date
    Jul 2011
    Posts
    5,442
    Text in a text box wraps automatically based on the width of the text box.

    If you want to artificially add carriage returns to the text you have to use CTRL-ENTER

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

Similar Threads

  1. Replies: 7
    Last Post: 01-31-2024, 09:57 AM
  2. Replies: 4
    Last Post: 06-16-2011, 09:30 PM
  3. No drop down list in Access?
    By snorkyller in forum Forms
    Replies: 5
    Last Post: 03-21-2011, 03:28 PM
  4. drop down list
    By tceicher in forum Access
    Replies: 5
    Last Post: 08-13-2009, 05:41 AM
  5. drop down wont display
    By gromit95 in forum Database Design
    Replies: 3
    Last Post: 10-21-2008, 11:12 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