If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Can only enter 4 characters in Client Table
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 |
#2
|
|||
|
|||
Can only enter 4 characters in Client Table
From what I can see, you have set up each text field to allow only 4
characters. -- Duane Hookom MS Access MVP "Steven Sutton" wrote in message ... 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 |
#3
|
|||
|
|||
Can only enter 4 characters in Client Table
Figured it out. Field size was set to 4 for some reason.
"Steven Sutton" wrote: 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 |
#4
|
|||
|
|||
Can only enter 4 characters in Client Table
On Tue, 14 Feb 2006 20:32:33 -0800, "Steven Sutton"
wrote: 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 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] |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Need to Improve Code Copying/Pasting Between Workbooks | David | General Discussion | 1 | January 6th, 2006 03:56 AM |
Autonumber using alphanumerics | Katharine Jansen | Database Design | 10 | August 24th, 2005 08:29 PM |
Access combo box-show name, not ID, in table? | write on | New Users | 30 | April 30th, 2005 09:11 PM |
Table Design | A. Williams | Database Design | 3 | April 29th, 2005 07:02 PM |
Table Wizard Does Not Set Relationship if Foreign Key and Primary Key Name Do Not Match Exactly in Case. | HDW | Database Design | 3 | October 16th, 2004 03:42 AM |