Freeze column headers in Report View

[sra2786]

I want to freeze the column headers in Report View so that when a user scrolls down they can see the headers. If this cannot be done in Access, is the only choice to link to the Access query in Excel to use Excel to freeze the headers? If I have to use Excel, does anyone have an example on how to link to an Access query and pass parameters to the query so I can filter the data that is returned.
Thanks.
Sandy

[ranman256]

Reports have headers wherever you want: top o page,top o group.

in excel , add a CONNECTION to the query.
this will post the data to a sheet.
freeze the headers on the sheet.

[isladogs]

Access report view is intended for showing the entire report as one long page on the screen - so it only has one header section and you can't freeze it.
However the solution is very simple.
View your reports in print preview with the header labels placed in the PageHeader section
Then view one page at a time

[pbaldy]

Another option would be putting the detail in a subreport and leave the headers in the main report.

[sra2786]

This worked great except I don't know how to get the preview not to be centered. I want the preview to be all the way to the left.
Thanks.
Sandy

[isladogs]

Set Autocenter = No in the report property sheet