Question: what is the difference between text and memo data type?
Answer: What's the Difference between a Text and a Memo Field? ... 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.