Access Report Page Header is not showing up, only the details.

Posted on 2008-11-12
Medium Priority
Last Modified: 2013-11-28
My access Report page header is missing even though I have the details on it.  I checked the page header property and it's set to "yes" on visible option.  Any other suggestions or recommendation to fix this problem.  thanks!
Question by:matrix7410
  • 2
LVL 85
ID: 22943991
I'm not sure what you mean by "even though I have the details on it". Does the header show in Design mode? How about Preview mode? What about when your print it?

Author Comment

ID: 22944877
What I meant was that the the report shows up without the labels in print preview and also when I print it out.  For example, this is the output I get
coney Island Hospital     7718-000-0000    21548745    Brookly   NY 11218

I want to have them labeled as:
Hospital    Telephone Number   TaxID    County       City    State

LVL 23

Accepted Solution

irudyk earned 500 total points
ID: 22946640
Here are some ideas...
Have you looked at the Visible property of the labels to see if they are set to Yes?
Also, is the report only 1 page in length? If so, look at the Format tab of the Report itself to see if the Page Header is set to something other than All Pages (e.g. it might be set to Not with Rpt Hdr) since that would suppress the page header from appearing/printing on 1 page reports.
Lastly, look to see if there is any VBA code that might be changing the visibility of the page header to No.

Author Comment

ID: 22949901
I appreciate all you guys help, but I found the solution.  I realized that on the report page veiw, when I clicked "File- page setup- Margin Tab -Print Data Only option needs to be checked off.  

Featured Post

Granular recovery for Microsoft Exchange

With Veeam Explorer for Microsoft Exchange you can choose the Exchange Servers and restore points you’re interested in, and Veeam Explorer will present the contents of those mailbox stores for browsing, searching and exporting.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Windows Explorer let you handle zip folders nearly as any other folder: Copy, move, change, and delete, etc. In VBA you can also handle normal files and folders, but zip folders takes a little more - and that you'll find here.
Sometimes MS breaks things just for fun... In Access 2003, only the maximum allowable SQL string length could cause problems as you built a recordset. Now, when using string data in a WHERE clause, the 'identifier' maximum is 128 characters. So, …
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…
Suggested Courses

862 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question