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!