Set a Maximum Size Limit for Long Text Fields

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? 

Members

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.  

•  Extended Cut Video - Silver
•  Database Download - Gold

Silver Members and up get access to view Extended Cut videos, when available. Gold Members can download the files from class plus get access to the Code Vault. If you're not a member, Join Today!

Recommended Course

• Access Developer 1: https://599cd.com/ACD1

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

Learn More FREE Access Beginner Level 1 FREE Access Quick Start in 30 Minutes Access Level 2 for just $1 Free Templates TechHelp Free Templates Blank Template Contact Management Order Entry & Invoicing More Access Templates

Resources Mailing List - Get emails when new videos released Consulting - Need help with your database Tip Jar - Your tips are graciously accepted Questions? Please feel free to post your questions or comments below or post them in the Forums.

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