border around detail section only

I am currently creating a report and would like to put a border that
encompasses a portion of my page header and all of the the data in the detail
section. My reports will be two pages so the border on the first page will
span most of the page and on the second page it will need to be smaller to
just encompass the few remaining records in the detail section to where the
report ends. Can anyone help with coding that could allow me to create this
type of border including where it needs to be written.

Thanks in advance.

Steel

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ports/200511/1

Assuming that your detail section is a fixed height (doesn't have any
controls with CanGrow set true) then can you just put the left and right
border lines in the detail section and the top and bottom border lines in
group header/footer sections? If you do have controls that can grow then this
won't work, as the left and right border lines would not grow and you would
get gaps in the border.

Jon.

"Steel" wrote:

I am currently creating a report and would like to put a border that
encompasses a portion of my page header and all of the the data in the detail
section. My reports will be two pages so the border on the first page will
span most of the page and on the second page it will need to be smaller to
just encompass the few remaining records in the detail section to where the
report ends. Can anyone help with coding that could allow me to create this
type of border including where it needs to be written.

Thanks in advance.

Steel

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ports/200511/1

What alternative is there? I also need a border (or column lines) between my
detail sections. Right now I need the text boxes to Grow as necessary but
the borders that I placed are outgrown when the text within the detail
increases.

"Jon Ley" wrote:

Assuming that your detail section is a fixed height (doesn't have any
controls with CanGrow set true) then can you just put the left and right
border lines in the detail section and the top and bottom border lines in
group header/footer sections? If you do have controls that can grow then this
won't work, as the left and right border lines would not grow and you would
get gaps in the border.

Jon.

"Steel" wrote:

I am currently creating a report and would like to put a border that
encompasses a portion of my page header and all of the the data in the detail
section. My reports will be two pages so the border on the first page will
span most of the page and on the second page it will need to be smaller to
just encompass the few remaining records in the detail section to where the
report ends. Can anyone help with coding that could allow me to create this
type of border including where it needs to be written.

Thanks in advance.

Steel

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ports/200511/1

You can use the Line method in the detail section's Print
event to draw the vertical lines:

Me.Line (0,0)-(0,30000) will draw a line at the left margin
Me.Line(Me.Width,0)-Step(0,30000) at the right margin
Me.Line(Me.textbox.Left,0)-Step(0,30000) at left of textbox
Me.Line(Me.textbox.Left+Me.textbox.Width,0)-Step(0,30000) at
right edge of textbox



ftrujill0 wrote:
What alternative is there? I also need a border (or column lines) between my
detail sections. Right now I need the text boxes to Grow as necessary but
the borders that I placed are outgrown when the text within the detail
increases.

"Jon Ley" wrote:
Assuming that your detail section is a fixed height (doesn't have any
controls with CanGrow set true) then can you just put the left and right
border lines in the detail section and the top and bottom border lines in
group header/footer sections? If you do have controls that can grow then this
won't work, as the left and right border lines would not grow and you would
get gaps in the border.


"Steel" wrote:
I am currently creating a report and would like to put a border that
encompasses a portion of my page header and all of the the data in the detail
section. My reports will be two pages so the border on the first page will
span most of the page and on the second page it will need to be smaller to
just encompass the few remaining records in the detail section to where the
report ends. Can anyone help with coding that could allow me to create this
type of border including where it needs to be written.
--
Marsh
MVP [MS Access]