Thanks for your help, I am now saving and preview mode and they seem
to not get it.
Then I asked what they expected.
OH its not the view its the data.
WHAT does that have to do with saving the data or just viewing it.
I can write a routine that saves it, previews it and on close deletes
the file.
No thats not it.

They have cut and pasted text into a note field.
when you export it the data may or may not all copy to excel on
export.

They are cutting and pasting from some online database, then pasting
it into a note field in access,  and it is full of funky punctuations.

The export routine gets confunsed on this mess and they expected
access to automatically clean it up for them.

1) how does this have anything to do with the preview and not what
they expected.
2) how do they expect access to reformat this mess and keep it at the
same time.
I tried to explain to them they are copying a bunch or returns and
tabs etc and just pasting this into a  note field and saying ok access
reformat this stuff.
I advised them to paste it into word or something and removing the
funky syntax.
That is not our job.

Sorry for asking about something they were sure was the problem with
out asking more from them. They seem to know everything but can't
explain it.

overall I hate Secretaries  OH excuse me Administrative Assistants