UtterAccess.com
We have detected that you are using an unsupported web browser. We recommend you to upgrade your web browser to get the most from UtterAccess forums.
Why should and how can I upgrade?
X   Site Message
(Message will auto close in 2 seconds)

Welcome Guest ( Log In | Register )

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

UtterAccess Addict
Posts: 206



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,156
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: 39,850
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

UtterAccess Member
Posts: 44
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



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,666
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

UtterAccess Addict
Posts: 206



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

UtterAccess Addict
Posts: 206



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

UtterAccess Member
Posts: 44
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

UtterAccess Addict
Posts: 206



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
 
+

Thank you for your support! Reply to this topicStart new topic

Jump To Forum:
 



RSS Search  ·  Go to Top  ·  Lo-Fi Version Time is now: 16th September 2014 - 02:25 AM