field size

  • Thread starter Thread starter Ruth
  • Start date Start date
R

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?
 
Change it to a Memo field.

That gives you around 64000 characters (about 8 pages, single-spaced.)
 
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


Allen Browne said:
Change it to a Memo field.

That gives you around 64000 characters (about 8 pages, single-spaced.)
Click to expand...
 
Ok-- thank-you It worked. I changed in the in incorrect table the first
time. Thank-you ver much!
--
Thank-you!
Ruth


Ruth said:
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?
Click to expand...
 
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.
 
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!
 
Back
Top