If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
Bring to front/send to back
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] |
#3
|
|||
|
|||
Bring to front/send to back
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] |
#4
|
|||
|
|||
Bring to front/send to back
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. |
#5
|
|||
|
|||
Bring to front/send to back
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. |
Thread Tools | |
Display Modes | |
|
|