Using the Memo Data Type in Microsoft Access

This simple and quick video tutorial talks about the ‘Memo‘ data type that can be used in a Microsoft Access table when designing new fields.

Most users tend to leave a text data type field to ‘Text‘ as it caters to most uses but if you want to store more than 255 characters (which is the maximum for ‘Text’) then the ‘Memo‘ data type is your other option.

Microsoft Access database – My Comments

As mentioned in the video, the ‘Memo‘ field can store up to around 65,000 characters which is more than enough for any field. Make sure that you only have one field (if any) set to this data type as you can not change the field length (as with the ‘Text‘ data type).

In essence, you preserve 65,000 bytes of space per record which Microsoft Access will start to perform poorly if over used – hence have only one field set with this type of data.

The added feature to Microsoft Access versions 2007 and 2010 is the ability to apply ‘Rich Text‘ formatting too which allow uses to format text in this field. Earlier versions of Microsoft Access only had ‘Plain Text‘. This is set in the design view of the selected field’s properties.

This entry was posted in Database Theory, MS Access, Tables and tagged , , , . Bookmark the permalink.

One Response to Using the Memo Data Type in Microsoft Access

  1. Ben Beitler says:

    If you need to have more than one ‘memo’ field for your table, consider using a second (related) table to hold other fields including multiple ‘memo’ data type fields which is only called when the second (linked) table is loaded normally via a query. The relationship can be set as ‘one-to-one’ relationship maintaining unique records to both tables.

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

Confirm you are human.