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

You can't set a maximum length for a long text field like you can for a short text field by setting the field size property. So in this Microsoft Access tutorial, I'll teach you how to use a validation rule to accomplish that task. Then, I'll show you a better method using the Before Update event and a tiny bit of VBA code.

Chloe from Eugene, Oregon (a Platinum Member) asks: My company prepares insurance claims. We have to submit a form to the insurance company outlining the details of a claim, however they have a maximum of 1000 characters. Is there any way to set a max limit on long text fields like you can with short text?

Silver Members and up get access to an Extended Cut of this video. Members will learn how to keep a running count of how many characters are remaining in a text box below your long text field. This way you can see the counter change each time you enter a character, and make it turn red when it's getting low. We'll learn about the Text and OldValue properties of a text box, the On Change event, and the On Undo events.

MEMBERS VIDEO:
https://youtu.be/4aMUFpTzF0I

BECOME A MEMBER:
YouTube: https://youtube.com/channel/UCl7-jJie4ifOVK87FINIuDg/join
or My Site: https://599cd.com/THMember

LEARN MORE:
Limit Long Text: https://599cd.com/LimitLongText

LINKS:
Validation Rules: https://599cd.com/Validation
String Functions: https://599cd.com/StringFunctions
Intro to VBA: https://599cd.com/IntroVBA
AfterUpdate: https://599cd.com/AfterUpdate
If Then: https://599cd.com/IfThen

RECOMMENDED COURSE:
Access Developer 1: https://599cd.com/ACD1

FREE TEMPLATE DOWNLOADS:
TechHelp Free Templates: https://599cd.com/THFree
Blank Template: https://599cd.com/Blank
Contact Management: https://599cd.com/Contacts
Order Entry & Invoicing: https://599cd.com/Invoicing
More Access Templates: https://599cd.com/AccessTemplates

ADDITIONAL RESOURCES:
FREE Access Beginner Level 1: https://599cd.com/Free1
$1 Access Level 2: https://599cd.com/1Dollar
Donate to my Tip Jar: https://599cd.com/TipJar
Get on my Mailing List: https://599cd.com/YTML
Contact Me: https://599cd.com/Contact
TechHelp: https://599cd.com/TechHelp
Consulting Help: https://599cd.com/DevNet
Twitter: https://twitter.com/LearningAccess
https://en.wikipedia.org/wiki/Microsoft_Access
https://products.office.com/en-us/access
https://microsoft.com/en-us/microsoft-365/blog/access/

KEYWORDS:
access 2016, access 2019, access 2021, access 365, microsoft access, ms access, ms access tutorial, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #learn, #lesson, #training, #database, before update, beforeupdate, max field size for long text fields, memo, validation rule, on change event, change, .text property, text box .text, textbox.text property, On Undo event, OldValue

QUESTIONS:
Please feel free to post your questions or comments below. Thanks.

Видео Set a Maximum Size Limit for Long Text (Memo) Fields in Microsoft Access канала Computer Learning Zone