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.