I have a text box on my VB6 application that I am using for long
notes. The data goes into SQL server database. The field is set up as
a "varchar" which only allows a length of 50 characters. However, I am
getting an error message...

"Multipe-step OLE DE generated errors. Check each OLE DB status value,
if available. No work was done."

I am not sure what this is? I think it may be due to typing in more
than 50 characters inside the texbox? Is there another type of field
that will accept more than 50 characters in SQL server?

Are you sure it is "...OLE DE Generated ..." not OLE DB?  - Typically
that is a very general error that says that your database call failed.

Does the insert ever work?  ie: if you only enter a few words?

Assuming that you are correct and it is the field size (which could
throw that error) Can you tell us what version SQL Server you are
using (I assume that it is Microsoft not Sybase SQL Server).

Assuming it a SQL Server 2000 - a "VarChar" can be up to 8,000
characters- you just need to define it as such in the table.
From:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_da-db_7msw.asp
"varchar-Variable-length non-Unicode data with a maximum of 8,000 characters."

Open SQL Enterprise Manager and find the table.  Right click on the
table and choose the Design Table command.  Change the length of the
field and press the disk icon in the upper left to save your changes
to the table design.  If you think users will ever type/paste in text
that is very, very long, you can always use the Text data type.  A
Text field can hold megabytes of data if need be.

Thanks Will. I changed this as you said and it corrected the problem.