Access report on the back - Help !

[luis.a.roman]

Have a report that is displaying on the back of a form. Why? Is there
anyway that I could print preview the report in front of the form?

I'm confuse...please help me put the report in front of the report.

Your guidance will be appreciated.

LUis

 

[Jerry Whittle]

Are you saying that the report is printing on the wrong side of a piece of
paper? What does this have to do with a form? Are you feeding a paper form
into the prints and having it overprinted by an Access report?

Please explain further.

 

[luis.a.roman]

Are you saying that the report is printing on the wrong side of a piece of
paper? What does this have to do with a form? Are you feeding a paper form
into the prints and having it overprinted by an Access report?

Please explain further.
--
Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.








- Show quoted text -

What I'm saying is that I when I do a print preview of a report, it
displays on the back of the form that I use to triger the report.

Hopefully, this help.

 

[John Spencer]

I think what you mean to say is

.... it displays IN (not "on the") back of the form ...


I understand you to mean that when you preview the report it is hidden
behind the form that you used to open the report.

One way to handle this is:

In the code that you use to open the report, add a line to set the
form's visible property to false.

Me.Visible =False

In the report, use code to like the following in the report's Close Event

Forms!YourFormName.Visible = True

 

[luis.a.roman]

I think what you mean to say is

... it displays IN (not "on the") back of the form ...

I understand you to mean that when you preview the report it is hidden
behind the form that you used to open the report.

One way to handle this is:

In the code that you use to open the report, add a line to set the
form's visible property to false.

Me.Visible =False

In the report, use code to like the following in the report's Close Event

Forms!YourFormName.Visible = True

---
John Spencer
Access MVP 2001-2005, 2007







- Show quoted text -

Thank you. I tried your recommendation and it works!