Seeking help creating catalog database (text descriptions >255 Char.)

[fvreg]

I am looking to create a catalog database. It is to serve as a finished product warehouse, as well as a product development tool. There are a number of fields, most of which are straight-forward.

One large problem I have is that the product descriptions are roughly 700 characters. Is there a way to have this information entered into Access and stored either in this database or elsewhere?
Any help would be GREATLY appreciated.

 

[daherb]

Make the field a memo instead of a text type that way you are not limited to 255 characters.

 

[fvreg]

many thanks. I have not used this feature in the past.

 

[daherb]

no problem

 

[gr026]

How do I make a field a memo type instead of a field type?
I am importing text from an excel file that contains more than 255 characters

 

[rajat]

open ur table in design view....change data type of field from text to memo...