Working with Tables

Close Window 

What's the Difference between a Text and a Memo Field?

Text and Memo fields both store text. So what’s the difference between the two?

When would you use the one, and when the other?

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.

(Posted 09/10/2001)