Results 1 to 5 of 5
  1. #1
    BAK2 is offline Novice
    Windows 7 64bit Access 2016
    Join Date
    Mar 2017
    Posts
    2

    Long Text Issue

    Hello:

    I am new to this (used Access years ago, but it's been awhile). In trying to create a table, I want one of the fields to be Long Text; however, whenever I switch from the default Short Text to Long in Design View, the Field Size Property row disappears from the General Tab below. When I try to add text beyond 255 characters, it does not populate, even though the Data Type indicates Long Text. What am I doing wrong?

    Thank you,

    BAK

  2. #2
    ranman256's Avatar
    ranman256 is online now VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    long text, (memo field) doesnt really have a limit in characters. Its normal.
    it IS limited to several megabytes.
    Just remember you cannot query on this field.
    255 is the longest text fields can hold, and CAN be queried.

  3. #3
    BAK2 is offline Novice
    Windows 7 64bit Access 2016
    Join Date
    Mar 2017
    Posts
    2
    Thank you for the response. So there really is no difference between the number of characters a short text and long text field can hold, since short text indicates 255. I will need to convert it to a Memo Field and remove it from any queries. Thanks again!

  4. #4
    Bulzie is offline VIP
    Windows 7 64bit Access 2007
    Join Date
    Nov 2015
    Posts
    1,463
    You can have memo fields in queries, you just can't use them to link to another table by that field.

  5. #5
    orange's Avatar
    orange is online now Moderator
    Windows 10 Access 2010 32bit
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716
    BAK2,

    Perhaps you could describe what you are trying to do without reference to data types.
    Just tell us in plain English the issue you are trying to solve. There may be options.

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

Similar Threads

  1. report textbbox for long text issue
    By MacAcc in forum Reports
    Replies: 2
    Last Post: 03-18-2016, 04:05 AM
  2. Long text query results.
    By Homegrownandy in forum Access
    Replies: 7
    Last Post: 02-24-2016, 07:18 AM
  3. long text question - I think ;-)
    By Jen0dorf in forum Access
    Replies: 2
    Last Post: 01-15-2016, 10:11 AM
  4. Long text or memo box filtering
    By data808 in forum Access
    Replies: 5
    Last Post: 02-12-2015, 04:55 PM
  5. Long Text Box
    By data808 in forum Access
    Replies: 5
    Last Post: 09-24-2014, 12:26 AM

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