on page property ...

  • Thread starter Thread starter jer
  • Start date Start date
J

jer

Any help / suggestions for a newbie would be reatly
appreciated. I have a 4 page report and because of
formatting I need to print the report with lines -
different for each page. Is there a way to format each
page differently. The following will format every page
similiarly but what I would like to do is format every
page in the report differently.
Me.ScaleMode = 5 '5=inches

Me.Line (0, 1.175)-(0, 6.325)
Me.Line (0.625, 1.175)-(0.625, 6.325)
Me.Line (1.75, 1.175)-(1.75, 6.325)
Me.Line (3.4875, 1.175)-(3.4875, 6.325)
Me.Line (11.4, 1.175)-(11.4, 6.325)

thanks in advance for your help
jer
 
You can add a text box to your report that is bound to
=[Page]
Then, in your code, you can use something like:
Select Case [Page]
Case 1
'code for first page
Case 2
'code for second page
Case Else
'code for all other pages
End Select
 
Duane Thank you very much
jer
-----Original Message-----
You can add a text box to your report that is bound to
=[Page]
Then, in your code, you can use something like:
Select Case [Page]
Case 1
'code for first page
Case 2
'code for second page
Case Else
'code for all other pages
End Select

--
Duane Hookom
MS Access MVP


jer said:
Any help / suggestions for a newbie would be reatly
appreciated. I have a 4 page report and because of
formatting I need to print the report with lines -
different for each page. Is there a way to format each
page differently. The following will format every page
similiarly but what I would like to do is format every
page in the report differently.
Me.ScaleMode = 5 '5=inches

Me.Line (0, 1.175)-(0, 6.325)
Me.Line (0.625, 1.175)-(0.625, 6.325)
Me.Line (1.75, 1.175)-(1.75, 6.325)
Me.Line (3.4875, 1.175)-(3.4875, 6.325)
Me.Line (11.4, 1.175)-(11.4, 6.325)

thanks in advance for your help
jer
Click to expand...


.
Click to expand...
 
Back
Top