.Microsoft Access provides two field data types to store data with text or combinations of text and numbers: Text or Memo.
Use a Text data type to store data such as names, addresses, and any numbers that do not require calculations, such as phone numbers, part numbers, or postal codes. A Text field can store up to 255 characters, but the default field size is 50 characters. To control the maximum number of characters that can be entered in a Text field, set the FieldSize property.
Use the Memo data type if you need to store more than 255 characters. A Memo field can store up to 64,000 characters. If you want to store formatted text or long documents, you should create an OLE field instead of a Memo field. To find out more about OLE fields, click .
Both Text and Memo data types store only the characters entered in a field; space characters for unused positions in the field aren't stored.
For more information on creating a text or memo field, click .