Can only enter 4 characters in Client Table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm using Access for college for the first time, and I cannot enter more than
4 characters in each field of the Client Table (name, address, etc.). Any
help would be appreciated. Thanks.

Steven
 
From what I can see, you have set up each text field to allow only 4
characters.
 
I'm using Access for college for the first time, and I cannot enter more than
4 characters in each field of the Client Table (name, address, etc.). Any
help would be appreciated. Thanks.

Steven
Click to expand...

Open the Table in design view. Select each of these fields, and make
sure that the datatype is Text; and the size (in the properties at the
lower left of the screen) is adequate for your data. My guess is that
you've somehow set the size of the field to... four characters.

John W. Vinson[MVP]
 
You must log in or register to reply here.

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
Linking fields in different table in same database 2
Is Access right for what I want to do? 0
How do I add data in a table and have it relate to another. 2
relational data base design 3
combine two or more fields in access 3
Access Automatically Send a notification email once a record is added 0
Access Access - Is it possible to repeat fields in a form? 1

Back
Top