field size

[Ruth]

Hi there

I have a database that has a note section, but the maximum field size is 255
characters. I want to put in notes up to around 800 characters. What is the
best way to do this?

 

[Allen Browne]

Change it to a Memo field.

That gives you around 64000 characters (about 8 pages, single-spaced.)

 

[Ruth]

Ok-- I changed it to a Memo in the table design view and saved the changes.
I input the data in a form and it still says that it is too large. Do I need
to change the setting somewhere else as well?
--
Thank-you!
Ruth

Change it to a Memo field.

That gives you around 64000 characters (about 8 pages, single-spaced.)

 

[Ruth]

Ok-- thank-you It worked. I changed in the in incorrect table the first
time. Thank-you ver much!
--
Thank-you!
Ruth

Ok-- I changed it to a Memo in the table design view and saved the changes.
I input the data in a form and it still says that it is too large. Do I need
to change the setting somewhere else as well?

 

[Allen Browne]

No: table design is the right place, Ruth.

Are you absolutely certain about this?
Double-check that the table still says Memo.
Double-check that the text box on the form is bound to the field you changed
to a memo.

Make sure the Name AutoCorrect options are off. In Access 2007, that's
under:
Office Button | Access Options | Current database.
In earlier versions it's:
Tools | Options | General
Then compact the database. In Access 2007:
Office Button | Manage
or in earlier versions:
Tools | Database Utilities.

 

[Ruth]

Hi Allen

I did make a mistake. I changed it in another table. It works now,
thank-you very much! I am so glad you helped me.
Have a fabulous day!