Page Numbers Now Missing

[JHennessey]

We've just upgraded to MS Office Professional 2003. My MS Access reports
used to be able to print page numbers, but now, they're no longer working!
Instead, each page prints #Name (italicized). I've tried to re-enter the
function via the INSERT PAGE NUMBERS, but to no avail. Any thoughts?

 

[Duane Hookom]

Does this happen on every report, even new ones?

Does this happen in every MDB, even new ones?

Have you attempted to compile your code?

 

[JHennessey]

Good Morning Duane! Thanks for such a FAST response. This happens one
"some" of my existing reports. I haven't had to write any new ones since the
upgrade. It does not happen on all of them.

I've even tried my own "workarounds" such as copy-and-paste from "working
ones" to the non-working with an update to Text Boxes, but to no avail.

Thanks,
Jeff

 

[Duane Hookom]

Do you have any fields in your report record sources named [Page] or [Pages]?

 

[Stockwell43]

Hi,

Try placing a textbox in the page footer section and place this in the
control source of the textbox:

="Page " & [Page] & " of " & [Pages]

If this doesn't work, try creating a new report with any selection of fields
just to see if it happens on new and existing reports. This way you can do a
process of elimination.

Hope this helped!

 

[JHennessey]

No...there are none. Thanks,Jeff

Do you have any fields in your report record sources named [Page] or [Pages]?
--
Duane Hookom
Microsoft Access MVP

Good Morning Duane! Thanks for such a FAST response. This happens one
"some" of my existing reports. I haven't had to write any new ones since the
upgrade. It does not happen on all of them.

I've even tried my own "workarounds" such as copy-and-paste from "working
ones" to the non-working with an update to Text Boxes, but to no avail.

Thanks,
Jeff

 

[Duane Hookom]

Have you tried compiling your code?

What are the exact properties of your text boxes that display #Name

Name:
Control Source:

--
Duane Hookom
Microsoft Access MVP

No...there are none. Thanks,Jeff

Do you have any fields in your report record sources named [Page] or [Pages]?
--
Duane Hookom
Microsoft Access MVP

Good Morning Duane! Thanks for such a FAST response. This happens one
"some" of my existing reports. I haven't had to write any new ones since the
upgrade. It does not happen on all of them.

I've even tried my own "workarounds" such as copy-and-paste from "working
ones" to the non-working with an update to Text Boxes, but to no avail.

Thanks,
Jeff

:

Does this happen on every report, even new ones?

Does this happen in every MDB, even new ones?

Have you attempted to compile your code?

--
Duane Hookom
Microsoft Access MVP


:

We've just upgraded to MS Office Professional 2003. My MS Access reports
used to be able to print page numbers, but now, they're no longer working!
Instead, each page prints #Name (italicized). I've tried to re-enter the
function via the INSERT PAGE NUMBERS, but to no avail. Any thoughts?