Changing the look of a sub-report

[Manc]

Morning

I have a report that shows individual records which contains a sub-report showing the individual record in more detail.

However, I am not keen on the sub-report formating showing on the main report, i.e. the field headers showing, the gridlines, the table and I want to get rid of it all, so just the text is visible. I can then add my own headings on the actual main report after.

I have made changes to the property sheet, turning off as much as possible and making items transparent but it's not enough.

Any ideas, whether VBA or anything, greatly appreciated.

Kind regards
Manc

 

[vbaInet]

However, I am not keen on the sub-report formating showing on the main report, i.e. the field headers showing, the gridlines, the table and I want to get rid of it all, so just the text is visible. I can then add my own headings on the actual main report after.

If you don't want the headers, wouldn't it be a simple matter of deleting them? What gridlines are you referring to? Gridlines are only visible in design view. If you mean the border, click the subreport once and set the Border Style to Transparent.

 

[Manc]

I have attached a zip file containing an excel spreadsheet called screenshot which show how the sub-report looks on the report.

See what I mean about formating? I don't want the column headers or the alternate row colours - just plain old text. I will then put the column headers on the main report.

Kind regards
Manc

 

[vbaInet]

Alright, I see your dilema. What you've done is you created the subreport based on a query.

To have more control over the look and feel of a subreport, what you should do is create a report based on the query, remove the Report Header/Footer and Page Header/Footer, save and close. Then set this report as the Source Object of your subreport control.

 

[Manc]

Thanks vbaInet, that is what I will do then. I will let you know the outcome.

Thanks for your time
Kind regards
Manc

 

[vbaInet]

Oki doki! I'm sure you will get it sorted.

 

[Manc]

Thanks vbaInet. Did what you suggested. Made the subreport form I was using into a query instead and put that into my report and voila, exactly how I want it to look.

I have however wandered into another stumbling block which perhaps you could shed some light on.

I have started a new post for it called "Trim expression on reports"

Thanks again vbaInet
Kind Regards
Manc

 

[vbaInet]

You're welcome! Will have a look at your new thread if I stumble upon it.