Macros with Print Preview

What are you print previewing? It will close a report or form, etc. If you
are print previewing a table and want to go back to datasheet mode, put
OpenTable and the table name is the macro and it will switch from print
preview to datasheet.

Bonnie
http://www.dataplus-svc.com

Cheryl wrote:

Will a macro close print preview. I had a macro perform other tasks, and then
open in print preview, however it will not close the preview.

Message posted via http://www.accessmonster.com

Cheryl,

Yes, a macro can be used to close a print preview. Can you tell us the
details (i.e. actions and arguments) of the macro you are using, and
what Event you are running it on?

Steve Schapel, Microsoft Access MVP

Cheryl wrote:

Will a macro close print preview. I had a macro perform other tasks, and then
open in print preview, however it will not close the preview.

Steve,
I am changing formats of dates and times, averaging a column, putting a
formula in another column, bolding and setting it up in print preview, but I
can't get it to close.
Cheryl/


"Steve Schapel" wrote:

Cheryl,

Yes, a macro can be used to close a print preview. Can you tell us the
details (i.e. actions and arguments) of the macro you are using, and
what Event you are running it on?

Steve Schapel, Microsoft Access MVP

Cheryl wrote:
> Will a macro close print preview. I had a macro perform other tasks, and then
> open in print preview, however it will not close the preview.

Cheryl,

I understand that it isn't closing.

But what is the macro? And where are you using the macro?

Steve Schapel, Microsoft Access MVP

Cheryl wrote:

Steve,
I am changing formats of dates and times, averaging a column, putting a
formula in another column, bolding and setting it up in print preview, but I
can't get it to close.

The close macro function doesn't work? Open the macro and select save as
module/code. Copy the code and paste in your next post so we can see what
it looks like.
"Cheryl" wrote in message
news:

Steve,
I am changing formats of dates and times, averaging a column, putting a
formula in another column, bolding and setting it up in print preview, but
I
can't get it to close.
Cheryl/


"Steve Schapel" wrote:

Cheryl,

Yes, a macro can be used to close a print preview. Can you tell us the
details (i.e. actions and arguments) of the macro you are using, and
what Event you are running it on?

Steve Schapel, Microsoft Access MVP

Cheryl wrote:
> Will a macro close print preview. I had a macro perform other tasks,
> and then
> open in print preview, however it will not close the preview.