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.

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.

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.

GetChunk perhaps.

--
Regards,
Tom Ogilvy


"bpaz_ph" wrote in message
...
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.