So, after making some (completely unrelated) edits to a report the [Page] of [Pages] that the wizard automatically sticks in the bottom right hand corner isn't working any more. I didn't touch the field other than resize it to be a but smaller (I have since resized it back to its original size but that did not fix it. It is now returning a "#Name?" error. The formula in the box is as follows (and as far as I can tell completely unchanged from how the report wizard set it up). Why is it no longer working?
="Page " & [Page] & " of " & [Pages]