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?"
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://youtu.be/tQWOpbvq-OA
Compact & Repair: https://youtu.be/CXd-6WwPkKY
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:
BECOME A MEMBER:
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
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
Richard's Blog: https://599cd.com/blog
Access Forum: https://599cd.com/AccessForum
Email Me: email@example.com
ms access short or long text, short text vs. long text, choosing field types
Please feel free to post your questions or comments below. Thanks.