Field Sizes

[quetzalc0atl]

Hello,

I have database that is linked to an asp style website. In my Products table, I have a field for Product_Description. Unfortunately the descriptions for the products that I have are very lengthy, some 10 sentences and above. And as access only allows for field sizes of 255 characters max, I can barely fit 1-2 sentences here.

I was wondering whether there is a way of getting a much bigger field size at all?

Any help would be greatly appreciated.

 

[Newman]

You can use «Memo» instead of «Text». But you've got to know that memo fields give some problems when used in some complex queries, such as with group by.