Short v. Long Text. What's the Difference (also Memo Fields)?

In this video we'll take a look at the differences between Short Text and Long Text fields, the benefits and drawbacks of each, when you should use each type, and we'll see how Long Text fields have been updated since the days of Memo fields in older versions of Access.

Brandon from Vermont (a Silver Member) asks, "I know in your classes you say to use Short Text for most fields and Long Text just for comments, but what are all the differences between the two, and when should I use each?"

Members

There is no Extended Cut for this video, but watch the Extended Cut for the Compact Importance video!

Links

Compact Importance: https://599cd.com/CompactImport
Data Types in FREE Access 101: https://599cd.com/Free1
Long Text Append Only: https://599cd.com/acx16
Rich Text Formatting: https://599cd.com/acx5
Text Field Sizes: https://599cd.com/TextFieldSizes

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.