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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
the 255 character limit per field 9
Access 2003 SendObject Macro 255 Character Limit 5
Linking to selected fields in an external table 4
Make Table Query Truncating Memo Field at 255 Characters 2
Exceed max columns error in access. 0
Custom list 255 character limit too small 1
How can I copy more than 255 characters in a cell without truncati 1

Back
Top