How can I expand 255 character field in Access?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Please help! I need to create a contact database and need more than 255
characters in one field, but that is the max size limit. What options do I
have?
 
Consider using the Memo datatype, this has a much higher limit however you
cannot easily sort by it.

If the field is required to contain notes or comments and you do not need to
process this other than displaying it on forms and reports then this should
be suitable.
 
Craig, how do I change the datatype of certain fields to memo? I cannot
figure it out.
Click to expand...

Open the Table in Design View.
Change the field's datatype from Text to Memo
Save the change.
 
Back
Top