How can I expand 255 character field in Access?

[Jackiec21]

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?

 

[Craig Alexander Morrison]

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.

 

[Hayden]

Craig, how do I change the datatype of certain fields to memo? I cannot
figure it out.

 

[fredg]

Craig, how do I change the datatype of certain fields to memo? I cannot
figure it out.

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

 

[Douglas J. Steele]

Open the table in Design mode, and then change the data type of the field.