Access - increase field text from 255

exp vg
exp vg used Ask the Experts™
on
Please offer if there is a way to increase the text count per field to be greater than 255. I have not found any solutions in my research.

Thank you.
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Top Expert 2016

Commented:
are you talking about a form control textbox?
if this a bound control, you have to change the table field data type to MEMO

Author

Commented:
In a regular table field. Thanks.
Distinguished Expert 2017

Commented:
255 is the maximum length of a text field.  If you need it to be longer, it must be a memo.
Ensure you’re charging the right price for your IT

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden using our free interactive tool and use it to determine the right price for your IT services. Start calculating Now!

Most Valuable Expert 2012
Top Expert 2014
Commented:
<no points>
In newer versions of Access, the "Memo" field is named "Long Text" (for some odd reason).
Distinguished Expert 2017
Commented:
How would we know it was a new version if MS didn't change names for objects that have existed for 20+years?
Top Expert 2016
Commented:
in access 2013 and 2016, Text (255) is now Short Text and the MEMO is now Long Text
Jim Dettman (EE MVE)President / Owner
Most Valuable Expert 2017
Most Valuable Expert 2012
Commented:
Their trying to align closer to other database products with naming.

Jim.

Author

Commented:
Thank you everyone - let me give this a try.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial