I need to print 30 pre-numbered blank line at end of report

  • Thread starter Thread starter Dennis
  • Start date Start date
D

Dennis

Hi,

OS: XP Pro with SP3
Access - XP Office Pro - SP3

While I have a lot of programming experience, I am an Access newbie. Thank
you for your patients and your help.

The end of my membership report needs to have 30 pre-numbered blank line at
end of membership report so users can hand write in new members names. The
number is their membership number.

I have manually placed 30 blank text boxes in the report footer. Each of
the 30 text boxes' label contains the underscore text. I programmatically
set the value of each of the 30 text values one at a time. Me.txtMem1 =
lngHighPostNo + 1, Me.txtMem2 = lngHighPostNo + 2, etc.

Is there a more elegant way to accomplish this or is brute force the only way?

Dennis
 
One way would be to create a little table with one field of type number.
Enter 30 records (the numbers 1 - 30.)

Then add a subreport based on this table to the Report_Footer section of
your main report.
 
Back
Top