[Last Call] Learn how to a build a cloud-first strategyRegister Now

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

subreport border (underline)

I have a subreport in a report and I had borders so I set all the borders to either transparent or none and now I have an underline under the subreport any ideas?

  • 3
  • 2
1 Solution
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
Can you post a screenshot of what you're referring to? Use an image format (like bmp or png or jpg) and NOT a Word Doc.
-GilAuthor Commented:
how do i do that?
Jeffrey CoachmanCommented:
Open your Report in Print Preview
Press the "PrntScrn" (printscreen key)
Open MS Paint
Click: Edit-->Paste
Click: File-->Save
Give your file a name
In the "Save as Type" box, select Jpeg (jpg)
Exit MS Paint.
Open this thread
Create a new comment
Check ON the: "Attach File" checkbox
Browse to, and select the jpg file you just created in MS Paint.
Click: OK
What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

-GilAuthor Commented:
I alson noticed that when I placed the subreport all the way to the left it created a lin on the left if on center only on bottom.

Jeffrey CoachmanCommented:

Well, from what I can, it looks like you have Lines "drawn" on the subforms.
(see the atteched screenshot)

So open the subforms themselves, and delete any "Lines".

Then preview this Main report again.
Then report back us to us.


-GilAuthor Commented:
Thank you.  
Sorry for late response.

Featured Post

NEW Veeam Backup for Microsoft Office 365 1.5

With Office 365, it’s your data and your responsibility to protect it. NEW Veeam Backup for Microsoft Office 365 eliminates the risk of losing access to your Office 365 data.

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