access report header

[LarrySr]

While I have worked with computer all my life I am new to Access. I managed to create my database and the report I wanted to generate. However; I cannot get the Report Header to print on all pages. It only prints on the first page. Can anyone help.

 

[Mr. B]

The Report Header will only print on the first page of the report. Try putting everything that you want printed at the top of each page in the Page header section.

 

[LarrySr]

How do I get it to let me add text to the Page header section? When I created the report it took the column name and put that in as the header for each column and that was OK with me but I could not figure out how to add additional text to the Page header.

 

[Mr. B]

Right click on the top of the report and select Page Header from the options.

 

[LarrySr]

When I do that it ask if I am sure I want to delete the Page Header!

 

[Mr. B]

This makes it sound like the Page Header section is already displayed. Sorry, but I thought from you post that this section was not visible.

You can extend the height of the Page Header section by clicking down on the top edge of the "Detail" section and drag it down. You can then move any of the column headings where you want them and just add the content you need.

 

[LarrySr]

I did as you suggested. I extended the Page Header and inserted a "text box" then typed in the text I wanted. I then deleted the Report Header field. When I tried to print my report it came up with a box asking me to enter a parameter. I canceled this and did some research. I noticed a small green triangle in the top left corner of the "text box" I added. When I held my mouse over this I found out this was and indication of an error. Checking further I found out it was an indication of an "Invalid Control Property: Control Source" error. Try as I did I could not correct this error. Here is what I put in my "text box". FAMILY AND FRIENDS - NAMES AND ADDRESSES

 

[boblarson]

In the control source of the text box you would need to put it in quotes and include the equals sign:

="FAMILY AND FRIENDS - NAMES AND ADDRESSES"

 

[SteveH2508]

Alternatively you could use a label for "FAMILY AND FRIENDS - NAMES AND ADDRESSES" if you want the same text every time. Set this in the caption property of the label.

 

[LarrySr]

The "label" worked great and did exactly as I wanted. Sorry to ask such dumb questions. I am teaching myself ACCESS by trial and error and I am sure that is apparent. Thank you for everything.