Print Blank Labels

[gschimek]

I have created a report using the Label Wizard to print nametags, 8 on a page. Each nametag has an event logo, some shared text, and then an individual name of an event attendee. So if there are 50 records in my table, I get 50 identical nametags, all with an individual event attendee's name on them. That part works fine.

But is there a way to print some "blank" nametags--some that just have the shared logo and text, but no name? Right now it prints 1 nametag for each record in my datasource table. But I also need 20-30 additional nametags that can be filled out by hand. Ideally, I'd like to be prompted each time for how many nametags to print, so that it can be flexible.

Any ideas? Thanks in advance.

 

[oldaf294]

labels

I doubt there is a solution to the "20-30" blanks when you are doing your report. However, if you create a new query and report for "Blanks" and link them to a Command Button on your Form:
Change the text color of the "namefield" to None or white and add this;
I have to still credit CosmoKramer for this solution in TekTips years ago.
Add a new table to your database with one field, numbers. Populate the field with numbers from 1 to how many you need.
Create a query based on your table.
Add the numbers table to the query (don't relate the numbers table) and place the [numberfield] in the design grid. In the criteria section of the [numberfield] type "Between 1 and [Quantity field]"
This allows you to print any number of blank labels, up to your maximum in the "Numbers" table.
jim