Question

What is the difference between text and memo field type?

Answer 1

Text and Memo fields both store text. ... AText 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.

Answer 2

Answer:

Text and Memo fields both store text. ... AText 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.