Lengthening a text field?

[rino_2]

Hi,

I have created a DAO database and have come across a big problem! The Database I have created was designed for large amounts of text, descriptions and the like. The problem is I can only fit very small amounts of text into each filed or I get an Error. Is there a way to lengthen the amount of text that an individual field will hold?

Thanks

[MartinLiss]

The limit for a text field is 255 characters, but you can change them to memo fields and then they will be able to hold much more data.

[rino_2]

Thanks for the info MartinLiss but could you please tell me how to change them to memo fields?

[MartinLiss]

Do you have Access? If so it's simple, just do Tables>Design then click in the Data Type field and choose Memo in the drop-down list.

I'm not certain how to do it programatically (although I could figure it out), but to add a memo field you would do

tdTableDef.CreateField(sFieldName, 12, nFieldSize)

The "12" represents the memo field type, and when it's 12, nFieldSize is ignored.

[Bestia_Pop]

I've a ms access memo field and I'm working with ADO
(on ASP, but i believe it doesn't matters)
i'km trying to run an update query passing the memo field's content by parameter...
Ok... here's the problem
The only way to make it work is defining it's data-type as adVarChar, size 255.
It works just fine with small strings (< 255 chars)... but I need more size...

Any ideas ???

Thanks
Bestia Pop

PD: Excuse my english...

[JHausmann]

Originally posted by Bestia_Pop
I've a ms access memo field and I'm working with ADO
(on ASP, but i believe it doesn't matters)
i'km trying to run an update query passing the memo field's content by parameter...
Ok... here's the problem
The only way to make it work is defining it's data-type as adVarChar, size 255.
It works just fine with small strings (< 255 chars)... but I need more size...

Any ideas ???

Thanks
Bestia Pop

PD: Excuse my english...

Define a public (aka Global variable) and use that instead of a parameter.