Access Reports design

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a report and the details can grow, what I want is to put a box around
the details, one box only, so that the details print and display only in the
box, I can't seem to do that is there a way.

Help
 
Carlo said:
I have a report and the details can grow, what I want is to put a box around
the details, one box only, so that the details print and display only in the
box, I can't seem to do that is there a way.
Click to expand...


Use the report's Line method in the Detail section's Print
event:

Me.Line (0,0) - Step(Me.Width, Me.Section(0).Height), , B
 
Yes that works but is there a way to create a box so that four or five detail
lines can be in it and still keep the header and footer in a set location?
 
Four or five? Maybe, but I would need more info.

If you really meant to say all the details in a group, then
use a Line control (horizontal) at the bottom of the group
header and another at the top of the group footer. Then use
the line method in the detail section's Print event to draw
the vertical lines:
Me.Line (0,0) - (0, Me.Section(0).Height)
Me.Line (Me.Width,0) - Step(0, Me.Section(0).Height)
 
Marshall:

That works good, I've got another issue I have a invoice I'm creating and I
want the detail section of the report to be a fixed size and have boxes
around the sum and unit price columns, is there a way to have fixed borders.

Carlo

Marshall Barton said:
Four or five? Maybe, but I would need more info.

If you really meant to say all the details in a group, then
use a Line control (horizontal) at the bottom of the group
header and another at the top of the group footer. Then use
the line method in the detail section's Print event to draw
the vertical lines:
Me.Line (0,0) - (0, Me.Section(0).Height)
Me.Line (Me.Width,0) - Step(0, Me.Section(0).Height)
--
Marsh
MVP [MS Access]

Yes that works but is there a way to create a box so that four or five detail
lines can be in it and still keep the header and footer in a set location?
Click to expand...
Click to expand...
 
I don't understand enough details about what this report
looks like or why what you used in the other report won't
work here. Could you provide more information?
 
Hello Marshal Its Roger in Edmonton
Found your information about drawing the boxes very useful works great, just
on additional request to go along with it.
How do you set the line drawing width? I have tried all I can think of and
the help availale on DrawWidth is for all intensive purposes useless to me.
Going to rate your post as useful because it sure was.

Marshall Barton said:
Four or five? Maybe, but I would need more info.

If you really meant to say all the details in a group, then
use a Line control (horizontal) at the bottom of the group
header and another at the top of the group footer. Then use
the line method in the detail section's Print event to draw
the vertical lines:
Me.Line (0,0) - (0, Me.Section(0).Height)
Me.Line (Me.Width,0) - Step(0, Me.Section(0).Height)
--
Marsh
MVP [MS Access]

Yes that works but is there a way to create a box so that four or five detail
lines can be in it and still keep the header and footer in a set location?
Click to expand...
Click to expand...
 
What was wrong when you attempted to set the DrawWidth? This works for me.

--
Duane Hookom
MS Access MVP


Roger in Edmonton said:
Hello Marshal Its Roger in Edmonton
Found your information about drawing the boxes very useful works great,
just
on additional request to go along with it.
How do you set the line drawing width? I have tried all I can think of and
the help availale on DrawWidth is for all intensive purposes useless to
me.
Going to rate your post as useful because it sure was.

Marshall Barton said:
Four or five? Maybe, but I would need more info.

If you really meant to say all the details in a group, then
use a Line control (horizontal) at the bottom of the group
header and another at the top of the group footer. Then use
the line method in the detail section's Print event to draw
the vertical lines:
Me.Line (0,0) - (0, Me.Section(0).Height)
Me.Line (Me.Width,0) - Step(0, Me.Section(0).Height)
--
Marsh
MVP [MS Access]

Yes that works but is there a way to create a box so that four or five
detail
lines can be in it and still keep the header and footer in a set
location?


Carlo wrote:
I have a report and the details can grow, what I want is to put a box
around
the details, one box only, so that the details print and display only
in the
box, I can't seem to do that is there a way.


:
Use the report's Line method in the Detail section's Print
event:

Me.Line (0,0) - Step(Me.Width, Me.Section(0).Height), , B
Click to expand...
Click to expand...
Click to expand...
 
Back
Top