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

[bkjweb]

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!

[June7]

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.