Horizontal lines in Access Report

domtrump

Board Regular
Joined
Apr 1, 2010
Messages
245
I create a new report in Access 2007. There is a blue hairline horizontal line across the top. After I resize fields, I need to resize the line. However, I cannot seem to find a way to select it! Is there some trick to selecting the line to resize it?
 

Some videos you may like

Excel Facts

Excel Joke
Why can't spreadsheets drive cars? They crash too often!

Trevor G

Well-known Member
Joined
Jul 17, 2008
Messages
6,362
Open the properties of the report and at the top of the properties there is a drop down if you select the drop down it will give you your line number then select it then its properties you can adjust the relevant parts.
 

domtrump

Board Regular
Joined
Apr 1, 2010
Messages
245
Open the properties of the report and at the top of the properties there is a drop down if you select the drop down it will give you your line number then select it then its properties you can adjust the relevant parts.
What exactly am I looking for in the drop down? I see things like "Report Header 1", "Text2", "Label3", etc. but I dont see anything with the word "Line" in it. Am I not understanding you correctly?
 

Trevor G

Well-known Member
Joined
Jul 17, 2008
Messages
6,362
Make sure you open the report in Desgin view and ensure you have the Report Properties selected, it should show you the word Line6 or some similar number in the list at the top in the drop down arrow.
 

domtrump

Board Regular
Joined
Apr 1, 2010
Messages
245
Make sure you open the report in Desgin view and ensure you have the Report Properties selected, it should show you the word Line6 or some similar number in the list at the top in the drop down arrow.
Well, I am looking in the right place, but there is no "Line#" in the drop down. Is it possible that it isnt a line object but some other type of formatting applied to the field label?

I created the report simply by clicking the REPORT button on the Create menu (from the ribbon).
 

BarbaraT

New Member
Joined
Nov 2, 2003
Messages
41
Well, I am looking in the right place, but there is no "Line#" in the drop down. Is it possible that it isnt a line object but some other type of formatting applied to the field label?

I created the report simply by clicking the REPORT button on the Create menu (from the ribbon).
I have exactly the same scenario -- I can see a line showing in the report, but it really doesn't seem to be a control. Nor does it seem to be an underline or outline of a control.

Any ideas as to what it is and how to resize it?
 

alansidman

Well-known Member
Joined
Feb 26, 2007
Messages
5,426
Office Version
2019
Platform
Windows
I was able to recreate this issue by creating a report using the wizard. To get rid of the line, you need to select all, (control A), then with the arrange tab on the ribbon selected, click on the remove icon. This separates all control movements from being in sync and eliminates the lines in question that separates the body of the report from the header.

I suspect that this was not obvious to most experienced forum participants because they seldom use wizards to create reports, forms or queries.

Alan
 

BarbaraT

New Member
Joined
Nov 2, 2003
Messages
41
That did the trick, though I'm still not sure what that line really WAS. Having to undo the whole layout to get rid of it seems like a convoluted process!

Thanks, though, since it is now gone and I could replace it with a specifically-drawn horizontal line that I can size however I want.
 

alansidman

Well-known Member
Joined
Feb 26, 2007
Messages
5,426
Office Version
2019
Platform
Windows
The line was part of the built in Themes of Access that arise when you use the wizard.

Alan
 

Eileen L

New Member
Joined
May 19, 2020
Messages
1
Office Version
365
Platform
Windows
I realize this is a really old question, but I had the exact same problem and the solution given here didn't solve it for me. However, I did finally stumble on the answer. The line was a picture. I found it in the form properties (or it may have been the form header?) and I was able to delete it there.
 

Watch MrExcel Video

Forum statistics

Threads
1,095,732
Messages
5,446,184
Members
405,390
Latest member
RafalKowalski

This Week's Hot Topics

Top