Solved

aCCESS 2003 Text field only allows 50 characters

Posted on 2009-04-08
2
264 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

Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Microsoft Office Picture Manager was included in Office 2003, 2007, and 2010, but not in Office 2013. Users had hopes that it would be in Office 2016/Office 365, but it is not. Fortunately, the same zero-cost technique that works to install it with …
This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.

911 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

16 Experts available now in Live!

Get 1:1 Help Now