Need to fill report with blank lines

[CSADataGirl]

I'm trying to help my husband with a checklist report. He has information for baseball card collecting sorted by year. Each year is on a separate page in our report. On pages that are not full (say there are only a dozen cards for that year), we want to fill up the rest of the page with blank lines (boxes really) that are the same size as the lines with data. How do I go about doing something like this?

Also, a related problem... he has some cards that are in a "Traded" or "Update" set which he wants listed separately, but on the same page. Actually, this is working fine, but how do I add a blank line above the "Traded Set" section that is the same size as the other lines with data?

 

[richary]

If you have a group header for the Year, set the "Force New Page" property to "After Section" to effectively get a page break after each set of records for that year.

I belive that will do what you wish.

 

[Rich]

Is this what you want?

 

[thesaurusrex]

Do you want actual lines so that you can write in additional cards by hand when not at the computer?

 

[CSADataGirl]

Yes, I want actual lines. I've attached a sample of the Excel report for the Cardinals list for 1951. We have everything looking right in Access except for the blank lines.

I tried opening the link/zip file that Rich sent, but I'm running Access 2003 and it wouldn't open the file. From the previous thread, it sounds like the coding he provided worked, but unfortunately, I couldn't even look at it with the 2003 version.

My husband found an article that talked about adding a line control and a text box to count the records in the group, then adding a module, but it didn't work for us. The article was written for Access 2000 and I don't know if that is the reason or if it's the fact that I couldn't figure out where to attach the module or how to customize it to match our field names.

The field names we use for this report are [Nickname] for the team, [Year] for the year (duh ), [Card] for the Card number, and [CardDescription] for the Player's name and other descriptive details for this particular card.

My knowledge would be considered novice level when talking about the behind the scenes programming (modules, VB, etc). So, if you do help me with examples could you please include my field names? Sorry to be such a baby.

Again, thank you for all the helpful advise and quick replies.
Peggy