I have a spreadsheet which get data from my MS Access memo field.

It happens the memo filed is longer than 1024 characters which Excel
only put the first 1024 characters. We are unable to print the whole
contents.

I tried to enter an enter have them in two paragraph, but it still has
1024 characters only.

Are there any workaround for this?

Your help is great appreciated,

hi
in xl help, type the word specifications. this will display the specs and
limit of your version of excel.
length of cell content- 32767 characters. only 1024 show in a cell. the rest
show in the fomula bar.
no way around this. it's an excel ceiling.

Regards
FSt1

"inungh" wrote:

I have a spreadsheet which get data from my MS Access memo field.

It happens the memo filed is longer than 1024 characters which Excel
only put the first 1024 characters. We are unable to print the whole
contents.

I tried to enter an enter have them in two paragraph, but it still has
1024 characters only.

Are there any workaround for this?

Your help is great appreciated,

If you add alt-enters (to force new lines within the cell) every 80-100
characters, you'll be able to see and print more than the 1000 (or so)
documented.

inungh wrote:

I have a spreadsheet which get data from my MS Access memo field.

It happens the memo filed is longer than 1024 characters which Excel
only put the first 1024 characters. We are unable to print the whole
contents.

I tried to enter an enter have them in two paragraph, but it still has
1024 characters only.

Are there any workaround for this?

Your help is great appreciated,

--

Dave Peterson