By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,224 Members | 1,143 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,224 IT Pros & Developers. It's quick & easy.

Reports..horozontal line where it is not needed or wanted..

P: 54
Hi (to the masters of chaos!!!)

I created a report using the wizard. (Access 2003).
It has the following sections:
Report Header
Page Header
Company Header
Detail
Page Footer
Report Header.

In the Company Header are among other things Column Headings for the data that is in the Details section.

Whenever I preview a report, just where the 'Details' bar is (when in design view) there is a horozontal line printed across the page. But it seems to begin about 25mm out from the left hand edge of the report(as seen in design view).

I cannot see the line to change its width to the full width of the page, though there are other horozontal lines that the wizard generated that do run from edge to edge of the report.(I mean width of the previewed report, not width of the printed report).

It doesn't seem to have anything to do with the page set-up which just happens to have a left margin of 25.45mm.

I have created another line just above the details section and dragged the detail bar up so it sits basically on top of the line I have created and it looks fine on the first page of the report, but on any subsequent pages the original line shows with its oddball width.

Any ideas how I can vanquish the offending line or change its width please?
Thanks again
Jan 4 '07 #1
Share this Question
Share on Google+
4 Replies


MMcCarthy
Expert Mod 10K+
P: 14,534
Hi (to the masters of chaos!!!)

I created a report using the wizard. (Access 2003).
It has the following sections:
Report Header
Page Header
Company Header
Detail
Page Footer
Report Header.

In the Company Header are among other things Column Headings for the data that is in the Details section.

Whenever I preview a report, just where the 'Details' bar is (when in design view) there is a horozontal line printed across the page. But it seems to begin about 25mm out from the left hand edge of the report(as seen in design view).

I cannot see the line to change its width to the full width of the page, though there are other horozontal lines that the wizard generated that do run from edge to edge of the report.(I mean width of the previewed report, not width of the printed report).

It doesn't seem to have anything to do with the page set-up which just happens to have a left margin of 25.45mm.

I have created another line just above the details section and dragged the detail bar up so it sits basically on top of the line I have created and it looks fine on the first page of the report, but on any subsequent pages the original line shows with its oddball width.

Any ideas how I can vanquish the offending line or change its width please?
Thanks again
If you check again you will find that the wizard put in a line either at the bottom of the Company header or the top of the details section. To check the company header just drag the details section down and you should see it. It could be over a grid line so look carefully.

If its not there move the cursor near the top of the details section but not over any other control click the mouse and then holding down the mouse pad drag the mouse over the top of the details section. The line should be highlighted and you can alter or delete it.

If neither of these works go to the object list which should be displaid on the menu/toolbar and choose any object the begins with line you should find it eventually.

Mary
Jan 5 '07 #2

P: 54
Thanks Mary

First Access report I have ever made...and it was a little daunting. The report wizard had drawn 2 lines pretty much on top of one another..I guess to make a slightly thicker line than 1pt. I had thought I had dragged the line to fill the width of the page but I hadn't realised there was another one directly or nearly directly underneath the one I had dragged...so I was doing what you suggested (after having remade the report 6 times in the thought that maybe there was a glitch with the program)..and couldn't see the prooblem. Finally I went to drag the line down and only then saw there were two squeezed together.

I dont know why it just didn't make a single line with 2 points or something.

That was using 'corporate style' it put two narrowly spaced lines at the top of the Company Name header but two on top of one another for the lower line.

Thanks again for all the assistance and if I have not said it before, happy new year!
Jan 5 '07 #3

MMcCarthy
Expert Mod 10K+
P: 14,534
Thanks Mary

First Access report I have ever made...and it was a little daunting. The report wizard had drawn 2 lines pretty much on top of one another..I guess to make a slightly thicker line than 1pt. I had thought I had dragged the line to fill the width of the page but I hadn't realised there was another one directly or nearly directly underneath the one I had dragged...so I was doing what you suggested (after having remade the report 6 times in the thought that maybe there was a glitch with the program)..and couldn't see the prooblem. Finally I went to drag the line down and only then saw there were two squeezed together.

I dont know why it just didn't make a single line with 2 points or something.

That was using 'corporate style' it put two narrowly spaced lines at the top of the Company Name header but two on top of one another for the lower line.

Thanks again for all the assistance and if I have not said it before, happy new year!
Happy New Year to you too.

You'll get the hang of it eventually. Access report styles add things like lines and frames to the report. Once you get used to them you will be able to get rid of any you don't want.

Mary
Jan 5 '07 #4

NeoPa
Expert Mod 15k+
P: 31,660
If you check again you will find that the wizard put in a line either at the bottom of the Company header or the top of the details section. To check the company header just drag the details section down and you should see it. It could be over a grid line so look carefully.

If its not there move the cursor near the top of the details section but not over any other control click the mouse and then holding down the mouse pad drag the mouse over the top of the details section. The line should be highlighted and you can alter or delete it.

If neither of these works go to the object list which should be displaid on the menu/toolbar and choose any object the begins with line you should find it eventually.

Mary
Nice answer Mary.
I know I'm often following behind picking small holes in your posts for fun, but just to show I also notice all the others (majority) where the answer's are perfect.
This one, particularly, I found helpful as I usually TAB from one control to another through the (sometimes very large) list of them all. Using the Object List tip is certainly going to prove a boon. Only, as in this case, where the controls are hard to detect easily.
Jan 5 '07 #5

Post your reply

Sign in to post your reply or Sign up for a free account.