Access 201:Print Preview Missing report navigation..

[PaulSc]

Hi, been searching for this for ages but no luck so after a bit of help/advice please......

Fairly standard Access report opened from a form with Openreport,repname,AcViewPreview

it creates a nice 238 page report however the Pages navigation bar at the bottom of the report is "missing"..?

I say missing because if you swap to report view then back to Preview it appears and you can navigate back/forth etc...

Anybody have any ideas why when the report opens it doesn't show this bar n=by default please..?
We have other databases where this doesn't occur and its same code, same references etc etc so puzzled...

TIA

PaulSc.
(p.s duplicate post in Access VBA Forum..Apologies...)

 

[dhookom]

This might be caused by the number of pages. Also, do you have any controls displaying [Page] or [Pages]?

Duane
Hook'D on Access
MS Access MVP

 

[PaulSc]

Cheers..

This happens just with this one database so far on anything with > 1 page...... and yes we are using the {page] of [Pages} to display in the footers...

Weve checked things like the code, references etc...weve even exported the report/query to another database and it works ok there (Its not really an option to build a new one for thi particular report as its one of 100's.........)

 

[dhookom]

I would try to make a copy of the same report and remove at least the [Pages].

Duane
Hook'D on Access
MS Access MVP