Discuss "Alpha Page Numbers" in the Microsoft Access forum.

Anyone know how to get A, B, C as page numbers on a report instead of 1, 2 , 3

Thanks

__________________
If i helped you, make me famous by clicking the

Not sure, but you might be able to do this for the page numbers in the control source:

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

you could put:
="Page " & chr(Val([Page])+64)

If your report went over 26 pages then you would have to do some error checking.
dunno if you have to use the val function either.

Make your control source for the page # something like this:
just hope you never have anything more than 26 pages ... this could break.

__________________
Quote of the Month:
Regret: It hurts to admit when you make mistakes - but when they're big enough, the pain only lasts a second.

Questions to Ponder:
Could it be that all those trick-or-treaters wearing sheets aren’t going as ghosts but as mattresses?

iif([sarcasm]=true,iif([you have to ask]=true,"didn't work","ha ha ha"),"not sarcasm")
copyright © 2008 sbenj69

Thanks to both of you,.. w000t ,.. can't rep ya sbenj,.. have to spread some more rep around first

Oh, exceeding 26 won't be a problem,.. the most i'd ever expect is 10 and there would have to be a serious problem for that