Amount of text cells can hold

  • Thread starter Thread starter Guest
  • Start date Start date
G

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



DOrtega said:
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
Click to expand...
help.
 
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.
 
?

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!)


Jeff C said:
a memo field will hold 250 characters
Click to expand...
help.
 
Back
Top