Thanks Tom,

I found time to debug my code and came up with an "error 40035" when I did a
Cstr in the memo field of my recordset. It turns out from the msdn library
that getRows() is unable pull the data from the recordset into the variant.
Is there a work around to this issue?

"Tom Ogilvy" wrote:

A cell can hold 32000+ characters.

Unless you embed hard line feeds (chr(10)) in the string, you will be
limited to seeing only approximately 1024 characters on screen and in print.
If you do embed the line feeds and reduce the font, you can get much more
(of course wrap text must be true).

--
Regards,
Tom Ogilvy


"bpaz_ph" wrote in message
...
I'm stuck with ms excel as an interface with ms access as my back-end.
This
started off as a simple project and as simple goes, evolved into complex.
My
problem is how to display a memo data type in excel OLE objects.

thanks in advance.