• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 575
  • Last Modified:

How to draw vertical lines on a continuous report with different sized boxes?

Hey Experts,

I have a report based on a query and sometimes the text boxes are different sizes and because of this it doesn't create a neat grid. I've had a look at creating the lines on the fly using the LINE function however I was wondering if there was an easier way to achieve this.
I've attached an example.

Thanks,
Norb
ReportExample.JPG
0
Norbert2000
Asked:
Norbert2000
  • 4
  • 3
  • 2
1 Solution
 
MINDSUPERBCommented:
Just use lines then format the texbox border as transparent.

Sincerely,
Ed
0
 
Norbert2000Author Commented:
Hi Ed,

Would it be possible for you to post example code of doing just the vertical lines right and left?

Cheers,
Norb
0
 
MINDSUPERBCommented:
Norb,

Just hold on, some other EE might give you a sample code that you need.

I never tried to use codes when I designed and positioned a line or any other objects in a report. I do it manually with patience by shifting print preview and design view most of the time until I made it perfect.

Sincerely,

Ed

0
Easily Design & Build Your Next Website

Squarespace’s all-in-one platform gives you everything you need to express yourself creatively online, whether it is with a domain, website, or online store. Get started with your free trial today, and when ready, take 10% off your first purchase with offer code 'EXPERTS'.

 
Norbert2000Author Commented:
Ed,

If I draw a line onto the report in design view won't I have the same problem? Once one of the textboxes grows the lines will no longer be the right height?

Norb.
0
 
Jeffrey CoachmanMIS LiasonCommented:
I've long since giving up on trying to make Access reports look like Excel spreadsheets (Grid style, with boxes that grow and shrink with text and texboxes.)
;-)

You can do it, ...but it may be more trouble than it's worth (IMHO) so see here:
http://www.lebans.com/PrintLines.htm

BTW, you did not state what version of Access you were using...
I believe Access 2007 and newer will do this (grow/shrink all controls in a row to the same height) by default.
(You just have to Size the controls to the grid, make the BorderStyle Solid, and but all the controls up against each other.)

JeffCoachman
0
 
Norbert2000Author Commented:
Hi Jeff,

It certainly seems a lot more trouble than it's worth, I am using 2007 but it doesn't seem to change the size of the controls automatically.

Thanks for the link, was really helpful.

Norb
0
 
Jeffrey CoachmanMIS LiasonCommented:
Again, this is why I stopped bothering with this effect years ago.
Bedsides all the jerking around to get it to work...

IMHO, the report looks much cleaner with just Horizontal lines separating the rows
;-)

JeffCoachman
untitled.JPG
0
 
Norbert2000Author Commented:
Hello Jeff.

Thanks for that I ended up not using vertical lines. Like you said they were causing too many problems ^^.

Norb
0
 
Jeffrey CoachmanMIS LiasonCommented:
;-)
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

  • 4
  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now