Can only enter 4 characters in Client Table

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Steven Sutton - 15 Feb 2006 04:32 GMT

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

Reply to this Message

Duane Hookom - 15 Feb 2006 04:39 GMT

From what I can see, you have set up each text field to allow only 4
characters.

Signature

Duane Hookom
MS Access MVP

> 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

Reply to this Message

Steven Sutton - 15 Feb 2006 04:48 GMT

Figured it out. Field size was set to 4 for some reason.

> 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

Reply to this Message

John Vinson - 15 Feb 2006 04:54 GMT

>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]

Reply to this Message