Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Label fields don't appear on Report 1

Status
Not open for further replies.

bcw

MIS
Oct 10, 2001
22
US
I'm printing a report with headings in the page Header. They are just standard label fields. The problem is the labels do not appear on the preview or printed forms of the report although they are there in design view.

I've tried adding new labels to every section of the report and none of them will show up. Text boxes in the same report show up with no problem in all sections of the report.

Is there a property somewhere that I'm missing that turns labels off? I've looked everywhere I can think of but can't seem to find anything. Thanks for the help.

Brian
 
Dear bcw,
Select one of the Labels in Design view that is not showing and go to View|Properties and select the Format Tab see if the Visible property is set to 'Yes'
HTH
Regards Jim
 
Thanks Jim...all of them are set to Visible=Yes. I've never seen a problem like this so it is really confusing me. I've checked out all of the properties for the labels, pageheader and report and can't find anything out of the ordinary. Any other ideas?

Thanks, Brian
 
Dear bcw
Found this in Access Help:
Troubleshoot printing and previewing reports
The column headings in my subreport don't print.

Microsoft Access doesn't print the page header and footer in a subreport, so if you put the labels for the column headings in the subreport's page header, they won't show up when you print the report.

If a subreport might span several printed pages, put the labels for the column headings in the subreport's group header, and set the RepeatSection property of the group header to Yes.
Regards Jim
 
thanks for the help Jim. I actually solved the problem. On the page setup there was a checkbox checked that said Print Data only. I guess that was making it so no labels anywhere on the report would print. I've never noticed that check box but thankfully I found it now. Thanks for the help.

Brian
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top