Results 1 to 2 of 2
  1. #1
    bkjweb is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Dec 2014
    Posts
    1

    Overflow error - converting text field to memo and copy to another table

    I am having a problem adding more data elements to a report. For some reason, I keep getting an overflow error when I attempt to add the Type, Areas, and Topics fields to the final report.

    I know that the Type field needs to be a memo instead of a text field. So, for some reason, I am getting an overflow error when I change the field to a memo field within the database. I have attached the code. Please let me know if you see something within the code that I need to change to go along with the change to a memo field.

    I am also a bit confused about the maximum number of characters for a memo field. In some places, I see that the max is 255. In others, I see that it's 1,000. I checked the data for my types field, and it goes up to 375 characters.

    Please share some insight.



    Thanks!
    Attached Files Attached Files

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,632
    Text field is limited to 255 characters, memo field is 65,535 characters. https://support.office.com/en-US/Art...rs=en-US&ad=US

    Type is a reserved word. Should not use reserved words as field names.

    Too much code for me to review.
    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.

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

Similar Threads

  1. Copy text file to Memo Field
    By HDobler in forum Programming
    Replies: 5
    Last Post: 06-25-2021, 02:21 AM
  2. VBA - copy memo, paste as text in email app
    By Goodge12 in forum Programming
    Replies: 5
    Last Post: 09-10-2014, 12:12 PM
  3. Help!! Converting memo to text in access
    By sandeebee123 in forum Access
    Replies: 1
    Last Post: 07-31-2013, 12:36 PM
  4. Replies: 5
    Last Post: 06-19-2012, 10:46 AM
  5. Overflow Error when converting data types
    By TinaCa in forum Programming
    Replies: 2
    Last Post: 06-09-2012, 08:54 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