a permanent frame for report

[ברקת]

Hello,
How do I put a permanent frame to a report?
I have problems with the right & left lines.

 

[Stefan Hoffmann]

hi,

How do I put a permanent frame to a report?
I have problems with the right & left lines.

What kind of problems?

btw, as this is English speaking news group, not really many people can
read your name. Can you maybe use a transcript?


mfG
--> stefan <--

 

[ברקת]

The problem is -
If I put lines in the left & right of Detailes,
the frame last only till the end of the data, and not till the footer.
I want it to be on all the page, permanently.

Thnx,
Bareket.

 

[Stefan Hoffmann]

hi Bareket,

If I put lines in the left & right of Detailes,
the frame last only till the end of the data, and not till the footer.
I want it to be on all the page, permanently.

Ah, okay. I don't know any smooth solution. The only thing you can do is
this:

You have to place lines also in the footer section and align them.


mfG
--> stefan <--

 

[John Spencer]

Use the line method to draw your lines.

Private Sub Report_Page()

Me.Line (50, 50)-(50, 9.5 * 1440), 0

End Sub

Lookup Line Method in the help.
--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..

 

[Stefan Hoffmann]

hi John,

Use the line method to draw your lines.

Private Sub Report_Page()

Me.Line (50, 50)-(50, 9.5 * 1440), 0

End Sub

Lookup Line Method in the help.

As I said, not a smooth solution


mfG
--> stefan <--

 

[John Spencer]

I'm sorry, I don't understand why you think that is not a "smooth" solution.

Perhaps our assumptions are different. I assumed that the user wanted to
draw a line (actually lines) from the top of the first detail to the top of
the page footer. I could have complicated the code by grabbing the height
of the footer section and the heights of any header sections. True if there
are group headers with can grow, etc. this could complicate the calculations
(and perhaps introduce failure).

ON the other hand if all the user wanted was to build a frame around the
page excluding the page header and page footer, all she would have to do
would be to define four lines. If the user wanted to change line widths,
colors, etc, then they would need to do further research on those calls

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..

 

[Stefan Hoffmann]

hi John,

I'm sorry, I don't understand why you think that is not a "smooth" solution.

Using code here is such a non-smooth solution. imho Access should be
able to render such a kind of object by itself. But it can't.

Perhaps our assumptions are different.

Maybe.


mfG
--> stefan <--

 

[ברקת]

John
Thank you, you helped me a lot.
Bareket.

Use the line method to draw your lines.

Private Sub Report_Page()

Me.Line (50, 50)-(50, 9.5 * 1440), 0

End Sub

Lookup Line Method in the help.
--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..