Increasing the 255 characters limit.

  • Thread starter Thread starter Jose V. Figueroa, CPA
  • Start date Start date
J

Jose V. Figueroa, CPA

Hi,

Does anyone knows if there is a way to go beyond the 255 characters in a
field.

I will appreciate any hints.

Thanks
 
Use Memo Field rather than Text Field.

Check Access Help on Text Field vs Memo Field.
 
Hi,

Does anyone knows if there is a way to go beyond the 255 characters
in a field.

I will appreciate any hints.

Thanks
Click to expand...

Use two fields or use a memo field or find a way of reducing the volume
of text.

I suggest all three because they all have value.

I have found that many times a user gets over wordy or the table design
is trying to put too much information in a single text field. In both cases
a correction of the problem usually improves performance and usability of
the database. It may take adding more fields.

I only suggest using two fields, because personal experience has shown
me that memo fields can be unstable. (I understand this may have been
addressed in the most recent versions of Access) It can be a real bother if
a memo filed gets corrupted.

There are times that a memo field is still the best solution.

There is no way to increase a text field beyond 255.
 
Back
Top