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.