I have a text box in my page footer with control source

="Page " & [Page]

This is supposed to give Page 1, Page 2, etc. However every page is coming out as Page 1. Any help is appreciated. Thanks!

I have a text box in my page footer with control source

="Page " & [Page]

This is supposed to give Page 1, Page 2, etc. However every page is coming out as Page 1. Any help is appreciated. Thanks!

It doesnt need the [] around the page.
To get Page x or y use
= "Page " & Page & " of " & Pages
or just to get Page x
= "Page " & Page

It doesnt need the [] around the page.
To get Page x or y use
= "Page " & Page & " of " & Pages
or just to get Page x
= "Page " & Page

Hi Fifty2One,

It puts the brackets around Page automatically. If I take them off it puts them back on. I changed it to
= "Page " & Page & " of " & Pages
but it still was Page 1 of 3 on every page. I even copied this from another report where it worked. There must be something weird about this report. This has worked on every other report I have used it on. Why would it not work on just this one report? The report does not seem to have any code behind it.

It doesnt need the [] around the page.
To get Page x or y use
= "Page " & Page & " of " & Pages
or just to get Page x
= "Page " & Page

Hi Fifty2One,

It puts the brackets around Page automatically. If I take them off it puts them back on. I changed it to
= "Page " & Page & " of " & Pages
but it still was Page 1 of 3 on every page. I even copied this from another report where it worked. There must be something weird about this report. This has worked on every other report I have used it on. Why would it not work on just this one report? The report does not seem to have any code behind it.

It should have the square brackets
="Page " & [Page] & " of " & [Pages]

I've had a number of really wierd problems with access where things stop working for no reason at all. Only the other day every event on a form i'd spent hours on stopped working for absolutely no reason. I ended up having to cut and paste the whole lot onto a new form which curiously fixed it...
Have you tried this? I bet that'll work

paultax,

I copied all the controls onto a new report and it worked. Thanks for the suggestion!