Changing the starting page number

  • Thread starter Thread starter Sara
  • Start date Start date
S

Sara

How can I tell MS Access what page to start numbering a
report - other than 1?

We store product information and print a listing for our
stores. When we get new products, we need to "add pages
to the book", and want to start with a page number of our
choosing (probably +1 over the last page we printed).
WORD does it so easily.
Thanks
 
Sara said:
How can I tell MS Access what page to start numbering a
report - other than 1?

We store product information and print a listing for our
stores. When we get new products, we need to "add pages
to the book", and want to start with a page number of our
choosing (probably +1 over the last page we printed).
Click to expand...

You didn't say how you want to specify how you want to
specify the starting page number. If all you need is a
popup prompt, then you can add a text box to the report
header. Let's name it txtStartPage and set its
ControlSource property to something like [Enter Start Page]
Then you can use a line of code in the report header's
Format event:
Me.Page = txtStartPage
 
Marsh -
It worked! I can't thank you enough. This is the first
time I've looked or posted online. Fantastic.
Sara
-----Original Message-----
Sara said:
How can I tell MS Access what page to start numbering a
report - other than 1?

We store product information and print a listing for our
stores. When we get new products, we need to "add pages
to the book", and want to start with a page number of our
choosing (probably +1 over the last page we printed).
Click to expand...

You didn't say how you want to specify how you want to
specify the starting page number. If all you need is a
popup prompt, then you can add a text box to the report
header. Let's name it txtStartPage and set its
ControlSource property to something like [Enter Start Page]
Then you can use a line of code in the report header's
Format event:
Me.Page = txtStartPage
Click to expand...
 
Back
Top