Bring to front/send to back

I have some verticle lines on a report. I wantr the lines to be at th back
of a cell that might contain text, in one row but to be shown beside/in front
of cells in another row.
It would be like send to back or in front of but I can't find these.
How could I do it?

Dean

Dean wrote:

I have some verticle lines on a report. I wantr the lines to be at th back
of a cell that might contain text, in one row but to be shown beside/in front
of cells in another row.
It would be like send to back or in front of but I can't find these.


No way using BringToFront because it is strictly a design
time operation.

If you;ll back up and provide more information about what
you are trying to do, maybe someone can suggest an effective
way to achieve the desired effect.

--
Marsh
MVP [MS Access]

Well,
I have a report that has two rows of data for each row (the comments field
is the width of a page and can grow) above it is a static row of tick boxes.
Each of the tick boxes is seperated by a drawn verticle line. For
continuity the line goes from the top of the detail row to the bottom but
this means it runs through the comments field.

I don't want this, is it possible to somehow put a secod detail row with the
comments field in or or or or......

Eg.

Tick!Tick!Tick!Tick!Tick!Tick!Tick!Tick!
Com!e!n! row! full! of t!ck li!nes !s we!l

The second row should read "Comments row full of tick lines as well"

"Marshall Barton" wrote:

Dean wrote:

I have some verticle lines on a report. I wantr the lines to be at th back
of a cell that might contain text, in one row but to be shown beside/in front
of cells in another row.
It would be like send to back or in front of but I can't find these.


No way using BringToFront because it is strictly a design
time operation.

If you;ll back up and provide more information about what
you are trying to do, maybe someone can suggest an effective
way to achieve the desired effect.

--
Marsh
MVP [MS Access]

It sounds like all you need is to use Line controls that go
from the top of the detail section to the top of the
comments text box. Probably with the text box AND the
section's CanShrink set to Yes.

Another approach is to use a Line control from the top to
the bottom of the detail section, but with the text box's
BackStyle set to Normal.

If you are using the Line method to draw the lines because
of the CanGrow and there is some blank space below the text
box, then draw two lines:

With Me.chk1
Me.Line (.Left, 0) - Step(0, ,Top)
Me.Line (.Left, .Top + .Height) - Step(0, 20000)
End With
--
Marsh
MVP [MS Access]


Dean wrote:
I have a report that has two rows of data for each row (the comments field
is the width of a page and can grow) above it is a static row of tick boxes.
Each of the tick boxes is seperated by a drawn verticle line. For
continuity the line goes from the top of the detail row to the bottom but
this means it runs through the comments field.

I don't want this, is it possible to somehow put a secod detail row with the
comments field in or or or or......

Eg.

Tick!Tick!Tick!Tick!Tick!Tick!Tick!Tick!
Com!e!n! row! full! of t!ck li!nes !s we!l

The second row should read "Comments row full of tick lines as well"

"Marshall Barton" wrote:

Dean wrote:

I have some verticle lines on a report. I wantr the lines to be at th back
of a cell that might contain text, in one row but to be shown beside/in front
of cells in another row.
It would be like send to back or in front of but I can't find these.


No way using BringToFront because it is strictly a design
time operation.

If you;ll back up and provide more information about what
you are trying to do, maybe someone can suggest an effective
way to achieve the desired effect.

Not sean or heard of it before, but I'll give it a go in the morning....
Thanks

"Marshall Barton" wrote:

It sounds like all you need is to use Line controls that go
from the top of the detail section to the top of the
comments text box. Probably with the text box AND the
section's CanShrink set to Yes.

Another approach is to use a Line control from the top to
the bottom of the detail section, but with the text box's
BackStyle set to Normal.

If you are using the Line method to draw the lines because
of the CanGrow and there is some blank space below the text
box, then draw two lines:

With Me.chk1
Me.Line (.Left, 0) - Step(0, ,Top)
Me.Line (.Left, .Top + .Height) - Step(0, 20000)
End With
--
Marsh
MVP [MS Access]


Dean wrote:
I have a report that has two rows of data for each row (the comments field
is the width of a page and can grow) above it is a static row of tick boxes.
Each of the tick boxes is seperated by a drawn verticle line. For
continuity the line goes from the top of the detail row to the bottom but
this means it runs through the comments field.

I don't want this, is it possible to somehow put a secod detail row with the
comments field in or or or or......

Eg.

Tick!Tick!Tick!Tick!Tick!Tick!Tick!Tick!
Com!e!n! row! full! of t!ck li!nes !s we!l

The second row should read "Comments row full of tick lines as well"

"Marshall Barton" wrote:

Dean wrote:

I have some verticle lines on a report. I wantr the lines to be at th back
of a cell that might contain text, in one row but to be shown beside/in front
of cells in another row.
It would be like send to back or in front of but I can't find these.


No way using BringToFront because it is strictly a design
time operation.

If you;ll back up and provide more information about what
you are trying to do, maybe someone can suggest an effective
way to achieve the desired effect.