different values for every page using vba

[lminmei]

i have a label in a report that takes a static value
now i want to have a different value for that label on every page...

page1, page2, page3, page4, page5, ...etc

label.caption would then show:
5, 10, 15, 20, 25 ... etc


how do i check each page in vba?

 

[Darrylles]

Hi,

Use a textbox to display your 5,10,15,20 caption.

Make it's 'Control Source'this:

=[Page]*5

Edit the textbox properties to look like a label (e.g. no border etc).

Regards,

Darrylle



Never argue with an idiot, he'll bring you down to his level - then beat you with experience. darrylles@yahoo.co.uk

 

[lminmei]

Darrylle,
thanks for the reply...
that's exactly what i did after i posted the thread but i used a label instead and just changed the caption property
thanks again.
Derek