Results 1 to 5 of 5
  1. #1
    oakhoplite is offline Novice
    Windows 10 Access 2013 64bit
    Join Date
    Apr 2018
    Posts
    9

    Question Add memo field in a form

    Hello!


    Can anyone tell me how to add a memo field in a form? (I cannot find what to click on). Help would be greatly appreaciated!

  2. #2
    June7's Avatar
    June7 is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,825
    Fields are in tables. Add field to table. The in form add a textbox and bind it to that field.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    oakhoplite is offline Novice
    Windows 10 Access 2013 64bit
    Join Date
    Apr 2018
    Posts
    9
    Is there any other way? Because the text box takes values from a column of a drop-down list (so I cannot link it to the field in the table).

  4. #4
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    no text boxes are connected to fields,( or are unbound)
    combo box values are in the combo box

    a memo field can be bound to a text box.
    NOTE: if you want a combo box field to fill a text box, you will only get 255 characters.
    you cannot load a memo this way.

    you can update a memo field using a code from the combo box and fill in the full memo data. (update query)

  5. #5
    oakhoplite is offline Novice
    Windows 10 Access 2013 64bit
    Join Date
    Apr 2018
    Posts
    9
    Thank you!

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

Similar Threads

  1. Replies: 9
    Last Post: 07-21-2014, 11:57 AM
  2. memo field truncating data on form
    By gillianw in forum Forms
    Replies: 11
    Last Post: 06-04-2013, 06:24 AM
  3. Add a memo field to existing form
    By snowboarder234 in forum Forms
    Replies: 0
    Last Post: 04-03-2013, 10:19 AM
  4. Expanding Memo Field in Form
    By AKQTS in forum Forms
    Replies: 3
    Last Post: 07-26-2010, 08:51 AM
  5. Memo field in form
    By swotr in forum Forms
    Replies: 1
    Last Post: 03-28-2009, 03:56 PM

Tags for this Thread

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