Solved

aCCESS 2003 Text field only allows 50 characters

Posted on 2009-04-08
2
263 Views
Last Modified: 2012-05-06
I have an Access 2003 form that I put a text box on to capture comments. The box is 7" long and 1.5" high, but I can only enter 50 characters into the box and then it won't accept any more. I scrolled through the properties, said it could grow, shrink, scroll bars, etc, but nothing I do will allow me to enter more than 50 characters.
HELP...
thx experts,
-Bob
0
Comment
Question by:bobrossi56
2 Comments
 
LVL 13

Accepted Solution

by:
lucas911 earned 250 total points
ID: 24097654
Change the table field size to 255.  Your field name is of "Text" data type and for the size change it to 255.
0
 
LVL 119

Assisted Solution

by:Rey Obrero
Rey Obrero earned 250 total points
ID: 24097656
open the table in design view and check the size of the field, change it to 255
0

Featured Post

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

Suggested Solutions

Entering a date in Microsoft Access can be tricky. A typo can cause month and day to be shuffled, entering the day only causes an error, as does entering, say, day 31 in June. This article shows how an inputmask supported by code can help the user a…
In this article we discuss how to recover the missing Outlook 2011 for Mac data like Emails and Contacts manually.
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…
Learn how to create and modify your own paragraph styles in Microsoft Word. This can be helpful when wanting to make consistently referenced styles throughout a document or template.

705 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now