Help with Microsoft Access?

Question

I am using Access 2000, it will only allow me to type 100 charachters per cell in the table. What is the deal?

Answer 1

Most likely the text field that you are editing has been defined (in the design of the underlying data table) as data type "Text" with a "Field Size" of 100.

You can change this by going into design mode in the appropriate data table and changing the Field Size. The maximum Field Size for a Text Field is 256 characters.

It's also possible (but less likely) that you are hitting a designed restriction in a form (either a validation check or an Input Mask).

Regards.

Answer 2

Open the database.

If you are in Datasheet view, click the drop down list from the View Button (first button on left on toolbar) and choose Design View.

If your database does not have an open form or table, then in the database window click on Tables on the left and select the table name on the right. Then Click Design view Tab at the top.

All your fields are listed. Note the second column which should be Data Type. All your fields should be "Text" which allows up to 255 characters.

Click any Field on the top.

Now look at the bottom part of the window under Filed Properties and the General Tab. The first item is "Field Size". Type in any number you want up to 255.

That should help.