Unwanted header in subreport

[MarkRennes]

When I print or print-preview a report with a subreport, a completely unwanted header appears and overwrites the first line of each subreport. It cannot be seen in report view. In appearance it is like a watermark: that is, it is faint while the actual data is in a normal font. The text is the name of the subreport, in this case, Feedback Message subreport. What do I need to do to get rid of this message? Thanks for your help.

 

[vbaInet]

Let's see a screenshot of the report in Print Preview and a screenshot in Design View.

 

[boblarson]

When I print or print-preview a report with a subreport, a completely unwanted header appears and overwrites the first line of each subreport. It cannot be seen in report view. In appearance it is like a watermark: that is, it is faint while the actual data is in a normal font. The text is the name of the subreport, in this case, Feedback Message subreport. What do I need to do to get rid of this message? Thanks for your help.

Ah yes, when you put a subreport on a report a label is generated which will sometimes be obscured in design view. The way to get a hold of it to delete is to use the drop down on the form properties dialog which you can then use to select any control. You may have to just go down the list until it is obvious that it has been selected (you'll see little black squares show up when a control is selected and this is no exception).

Once you have selected it with that drop down, you can then hit the delete key to get rid of it.

See here for a visual on what I'm talking about (this sample is for 2000-2003 but the concept is the same in 2007/2010 just that the properties dialog looks different).

 

[MarkRennes]

Hello and thanks for the suggestion. I'm new on this forum and cannot as yet upload images. I've "emptied" my database of sensitive data and compacted it so that I can attach it (an exercise which has taken all afternoon, getting a 7Mb database down to 2Mb, the forum limit). The problem is apparent when you open the Student Results report in print preview mode; the subform has the strange output.

Many thanks for helping and no doubt telling me I've made a stupid mistake somewhere! I'm experienced with Access but not strong on reports.

 

[boblarson]

You should put that it is a 2010 database as not everyone has that yet. I went throught the trouble to try to download and it doesn't open with 2007 because some 2010 features must have been used.

Also, did you try what I suggested? I'm 99% positive that is the problem.

 

[MarkRennes]

Thanks to vbaInet for your suggestion and to Bob Larson, whose answer has solved my problem!

Bon week-end, as we say in these parts...

 

[MarkRennes]

You should put that it is a 2010 database as not everyone has that yet. I went throught the trouble to try to download and it doesn't open with 2007 because some 2010 features must have been used.



Also, did you try what I suggested? I'm 99% positive that is the problem.

1. Sorry to cause you unnecessary work. Yes, it's Access 2010, and yes, the database does use 2010 features.
2. Yes, as I've already said, your suggestion was 100% helpful. Many thanks.

 

[vbaInet]

Bon week-end, as we say in these parts...

Would that be France?

 

[MarkRennes]

Yep! Rennes, France - a city with a population a litlle lower than - say - Brighton at about 210,000. It's in Brittany, in the north-west of the country. Main activities are telecommunications, car-making, education (60,000 students) and administration - France is the happy home of bureaucracy