Set a Maximum Size Limit for Long Text (Memo) Fields in Microsoft Access

[@Jojosmith342]

thumbs up as always for the GREATEST TEACHER Richard Rost who always makes our work life easier. Thank you for your valuable lesson 👍

[@JF-em6hr]

This answered my question fast. Now back to work. Thank you.

[@599CD]

Glad to help

[@malcolmdavidson6254]

Hi there Richard, you are an excellent teacher, thank you! Quick MS anomaly, I wondered if you knew about? LongText data type. After 2032 chars the text field will not update? Any thoughts? thanks.

[@599CD]

599cd.com/QQ

[@malcolmdavidson6254]

@@599CD Thanks for replying. I look forward to your response on the QQ forum. I am a huge proponent of coherence and structure with any code development and your classes really help gaining a logical understanding of the subject matter.

[@stephenbeswick2163]

Hi Richard another great video Steve..

[@599CD]

Thanks

[@Ded9822]

I’d like to know how to append a table with more than 255CHR in long text field. Access truncates the characters to 255 despite it being a long text field. Interested if you or anyone has a solution

[@599CD]

When exactly is this happening? Tell me here: 599cd.com/Ask

[@rabidfollower]

I've always felt that short text is too short (255 bytes isn't even enough for a tweet) and long text 1 GB size is too big, and it's too bad there is nothing in between. SQL Server lets you specify text fields of any size with varchar(n). But if n > 255 and you import the field into Access, it's turned into long text instead.

[@599CD]

Yeah... I've personally never had a problem with it. Usually if something goes over 100 characters or so, it goes in a Memo... er... I mean "Long Text" field. :)

[@Stache987]

I've always pronounced it ore-e-gun not ore-uh-gun

[@599CD]

Thanks