Hi All,

First, I did a search here but didn't find anything that was prudent
so,

In AccessXP I have a continuous form setup as a filter by form which
users use to filter and create subsets of records they want to work
with, they then using Office Links - Analyze with Excel memubar item
output the results to Excel XP. unfortunately two of the fields are
'memo' fields and of course only the first 255 characters actually get
output to the spreadsheet.

How do I get the entire contents of the memo fields to output to the
spreadsheet??? remember this subset of data sitting in a continuous
form, not a table.

Does AccessXP have specification sheets?? I looked but didn't find any
kind of thing.
thanks
bobh.

Hi,

bobh wrote:
Your problem is discussed in this knowledge article :

http://support.microsoft.com/kb/294286/en-us

Regards
Jens

On Mar 3, 3:19*pm, "Jens Schilling"
<JensSchillingBitteLoesc... (AT) fissership (DOT) de> wrote:
Thanks for the link but
Method 1 does not work, it still truncates a memo field at 255
characters, at least here in my shop and even if it did work, I could
not train all my users to it. I definately can not use method 2,
that's a manual end-user type process and again I can't be training
users how to work a spreadsheet.
The process I'm building is an automated process that gets filtered
data from a continious form to a spreadsheet where the end users is
just clicking on one or two menubar items hence "Office Links -
Analyze with Excel"
bobh.

bobh wrote:

I think you could automate the process where you loop through increments
of 255 chars. Maybe send your memos to a text file. Update the
spreadsheet then read the text file.

On Mar 5, 1:08*pm, Salad <sa... (AT) oilandvinegar (DOT) com> wrote:

I think that would be very complicated and difficult, create a
spreadsheet then a text file with the memo field and than update the
spreadsheet from the text file, I would not know where to begin.