UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

 
   Reply to this topicStart new topic
> Continuous Vertical Lines on a Report    
 
   
alfrado
post Dec 18 2008, 02:31 PM
Post#1



Posts: 206
Joined: 20-July 06



As anyone figured out to have continuous vertical lines on an Access report. Especially with text boxes that are set to "Can Grow" and "Can Shrink"
lfrado
Go to the top of the page
 
BananaRepublic
post Dec 18 2008, 02:33 PM
Post#2


Admin under the bridge
Posts: 1,288
Joined: 16-June 07
From: Banana Republic


Not knowing the exact format of your report, but last time I did that, I just made the line's height as high as the section it was in. It would then appear continuous in preview. You should just copy the height value from section properties and paste it in the line's height property, rather than doing this via GUI.
TH.
Go to the top of the page
 
R. Hicks
post Dec 18 2008, 02:40 PM
Post#3


UA Forum Administrator
Posts: 40,229
Joined: 8-February 00
From: Birmingham, Alabama USA


I agree with the Banana dude ...
If you extend the vertical line to the end of the section .. it should continue as the section grows (or shrinks) ...

RDH
Go to the top of the page
 
tboggs
post Dec 18 2008, 03:01 PM
Post#4



Posts: 44
Joined: 19-November 07
From: Atlanta, GA


This is the code from one of my reports. Use this as an event procedure in the On Print line of the Events tab of your detail properties...
Private Sub Detail_Print(Cancel As Integer, PrintCount As Integer)
Me.ScaleMode = 1
Me.ForeColor = 0

Me.Line (0 * 1440, 0)-(0 * 1440, 14400) 'Left Margin
Me.Line (1.9 * 1440, 0)-(1.9 * 1440, 14400) 'Before Deficiency
Me.Line (6 * 1440, 0)-(6 * 1440, 14400) 'Before Red
Me.Line (6.6 * 1440, 0)-(6.6 * 1440, 14400) 'Before FTT
Me.Line (7.2 * 1440, 0)-(7.2 * 1440, 14400) 'Before Y1
Me.Line (7.8 * 1440, 0)-(7.8 * 1440, 14400) 'Before Y2
Me.Line (8.4 * 1440, 0)-(8.4 * 1440, 14400) 'Before Y3
Me.Line (9 * 1440, 0)-(9 * 1440, 14400) 'Right Margin
End Sub
This creates eight vertical lines that fill the detail section whether it grows or not. I suggest using comments after each line so you know which line you're dealing with.
Go to the top of the page
 
vtd
post Dec 18 2008, 03:10 PM
Post#5


Retired Moderator
Posts: 19,667
Joined: 14-July 05



See Microsoft Knowledge Base article 286247.
Go to the top of the page
 
HiTechCoach
post Dec 18 2008, 03:25 PM
Post#6


UtterAccess VIP
Posts: 18,710
Joined: 29-September 03
From: Oklahoma City, Oklahoma


I find this code very useful:
Print Lines
Go to the top of the page
 
alfrado
post Dec 18 2008, 04:14 PM
Post#7



Posts: 206
Joined: 20-July 06



Thanks everyone for the responses. However, I may not have explained myself very well or I’m missing the information provided.
I have a report with approximately 500 entries with about 10 columns. 3 columns are numbers and the rest are text, and 3 of those columns are memo fields with a considerable amount of text.
I need to separate the columns by vertical lines but when I put a vertical line between the columns they do not grow or shrink with the amount of text.
Unfortunately, I need to replicate an Excel report which of course has no problem having both vertical and horizontal lines.
Thanks again
Alfrado
Go to the top of the page
 
alfrado
post Dec 18 2008, 04:52 PM
Post#8



Posts: 206
Joined: 20-July 06



After some playing with the example provided by tboggs I have successfully created vertical lines (Left and Right margines) down the whole report.
uestion: How do I stop the lines short of the footer? How would I stop the lines for one or two rows and then start them again?
Once again thanks
Alfrado
Go to the top of the page
 
tboggs
post Dec 19 2008, 08:23 AM
Post#9



Posts: 44
Joined: 19-November 07
From: Atlanta, GA


Can you post an example of the footer reference? Stopping the lines for a couple of rows might be an issue since the vertical lines aren't really related to data, they're just drawn every time the detail renders.
Go to the top of the page
 
alfrado
post Dec 19 2008, 01:48 PM
Post#10



Posts: 206
Joined: 20-July 06



Thanks tboggs, given the information you provided I was able to work my way through the footer issue, it just took me a little while. As suggested, stopping the lines for a couple of rows appears to be a little more challenging but I did come up with a temporary solution by putting a box with white fill over the lines. I will continue to experiment with it but it not that important. Everything else works fine.
Thanks again
Alfrado
Go to the top of the page
 


RSSSearch   Top   Lo-Fi    5th May 2015 - 05:20 PM