|Working with Tables|
Text and Memo fields both store text. So what’s the difference between the two?
A Text field is for relatively short entries, because it can’t hold more than 255 characters; a Memo field can hold up to 65,535.
You can use the Field Size property to limit the number of characters a Text field will hold; you can’t with a Memo field.
When would you use the one, and when the other?
A Memo field has a specific purpose: to store extended entries. Use a Memo field when you need lots of room. Typically, Memo fields have names like “Comments,” “Notes,” or “Remarks.” You get the idea.
One more thing; and it’s important: You can’t index a Memo field. If you intend to use a field as the common field in a table join, you have to make it a Text field, rather than a Memo field.