Amount of text cells can hold

[Guest]

I am creating a database that contains information on company projects that
include the client's name, construction cost, square footage, subconsultant
information and a description of the project itself. I have included
everything except the project description. This information can be anywhere
from 1 to 5 paragraphs of text. Is it possible to do this in Access or will
I have to do without including the project description? Thank for any help.

 

[Rick B]

Have you looked at the types of fields available and the description for
each type? Have you used the built-in help files?

A memo field will hold several paragraphs of text. Go to your table design
view and look at the help files for more details.

--
Rick B

I am creating a database that contains information on company projects that
include the client's name, construction cost, square footage, subconsultant
information and a description of the project itself. I have included
everything except the project description. This information can be anywhere
from 1 to 5 paragraphs of text. Is it possible to do this in Access or will
I have to do without including the project description? Thank for any

help.

 

[Guest]

a memo field will hold 250 characters

 

[Van T. Dinh]

A Text Field can store 255 characters. A Memo Field can store up to 2 GB of
characters. Not that you want to store that many characters in a Memo Field
value since an Access database also has a max. size of 2 GB. Also, a std
TextBox can only display 64 K characters.

 

[Douglas J Steele]

?

A memo field can store up to 64,000 characters.

Even a text field can hold up to 255 characters...

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

a memo field will hold 250 characters

help.