page number does not change (1 Viewer)

[pbuethe]

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!

 

[Fifty2One]

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

 

[pbuethe]

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.

 

[pbuethe]

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.

 

[paultax]

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

 

[pbuethe]

paultax,

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