Short Text v. Long Text in Microsoft Access. What's the Difference (also Text v. 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 (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?"

LEARN MORE:
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

RELATED VIDEOS:
Text Field Sizes: Optimizing Short Text Field Sizes in ...
Compact & Repair: Compact & Repair your Microsoft Acces...

BONUS FOR CHANNEL MEMBERS:
Silver Members and up get access to an EXTENDED CUT of this video which covers additional examples. That video covers about 3 hours of me building two databases to test the efficiency of short text, long text, compact & repair, and more. See below for a list of all the topics covered in the Member's video.

MEMBERS ONLY VIDEO:
Compact & Repair your Microsoft Acces...

BECOME A MEMBER:
@599cd

MEMBERS TOPICS:
Open Another Database: https://599cd.com/shellex
Sleep Function: https://599cd.com/sleep
Compact & Repair: https://599cd.com/compact
Read & Write Text Files: https://599cd.com/file+io
Get File Size: https://599cd.com/filelen
Delete a File: https://599cd.com/kill
Rename a File: https://599cd.com/rename
Recordsets: https://599cd.com/recordset

ADDITIONAL RESOURCES:
FREE Customer Template Database: https://599cd.com/XCDT
FREE Access Level 1: https://599cd.com/Free1
$1 Access Level 2: https://599cd.com/1Dollar
Your Questions Answered: https://599cd.com/TechHelp
Learning Connection 50% OFF: https://599cd.com/Connection
Survey: https://599cd.com/survey

Richard's Blog: https://599cd.com/blog
Access Forum: https://599cd.com/AccessForum
Twitter: Twitter: LearningAccess

Email Me: [email protected]

https://en.wikipedia.org/wiki/Microso...
https://products.office.com/en-us/access
https://microsoft.com/en-us/microsoft...

ADDITIONAL KEYWORDS:
ms access short or long text, short text vs. long text, choosing field types

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