Weird Problem - (0x80020009)

[ngaisteve1]

Microsoft OLE DB Provider for ODBC Drivers (0x80020009)
Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.

This is really weird. I have list of item after I selected it via a combobox. Each item has a link to view the full profile of that item. What is weird is this error message (above) only appeared on on particular item. The other item, no problem. I wonder why this problem occured.

Thanks.

[ngaisteve1]

I have found out the particular field for this problem. I also realized that if that field is empty but not null will has this error message. The datatype of this field is text. How do I solve this? Should I change the datatype?

[Dr. Web]

you can select the field with the trim function to remove any spaces.

select trim(name) from blah... blah... blah....