ADO problem

[elziko]

I'm trying to write the rich text contents of a rich text box to a memo field in an ADO recordset:

recmdb.Fields("Description&quot = DescriptionText.TextRTF

How ever I'm given the following error:

Multi-step operation generated errors. Check each status value.

What on earth does this mean and why can I not write rich text to this field. Writing normal text seems to work fine. I thought rich text was just text with formatting strings???

Any advice??

elziko

 

[NipsMG]

elziko:

Most likely, the problem is the string of text you are trying to write to the field is TOO LONG. (i.e. trying to write a 100 character string to a 50 character long varchar field).

Make sure the length of the string you are assigning to the field is less than or equal to the field's defined size.(recmdb.Fields("Description&quot.DefinedSize)

--NipsMG

 

[elziko]

Oh, of course. I thoughtI'd set the field to be a memo field.

Thanks a lot. The ADO error msg could have been more descriptive though!

elziko

 

[NipsMG]

Yeah I know.

ADO likes to use that error message for everything.. It's really aggrivating..

If you keep with ADO You'll begin to know exactly what's wrong just by the context of the expression iteself and the code around it.

--NipsMG