Label Printing

[Wayne]

I have a simple database of addresses each with unique key and the user
is able to create a table of selected keys and how many labels they
need for each. The print program, using label counting techniques,
shows, in print preview, the correct number of labels.
When printed, though, the first keyed entry sometimes prints correctly
with, say, 6 labels, or sometimes with 2 or 4. All the following keys
have their correct number of labels printed.
In Access 2000 but tried in 2003 with same result and to different
printers.

[Allen Browne]

How are you instructing Access to print the quantity of each label?

One common approach is to use code in the reports events. This won't work
reliably: it has exactly the problems you describe.

For details and an alternative, see:
Printing a Quantity of a Label
at:
http://allenbrowne.com/ser-39.html

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Wayne" <wa***********@nhs.net> wrote in message
news:11**********************@p79g2000cwp.googlegr oups.com...

I have a simple database of addresses each with unique key and the user
is able to create a table of selected keys and how many labels they
need for each. The print program, using label counting techniques,
shows, in print preview, the correct number of labels.
When printed, though, the first keyed entry sometimes prints correctly
with, say, 6 labels, or sometimes with 2 or 4. All the following keys
have their correct number of labels printed.
In Access 2000 but tried in 2003 with same result and to different
printers.

[w_a_n_n_a_l_l_ -]

On 13-Jun-2006, "Allen Browne" <Al*********@SeeSig.Invalid> wrote:

For details and an alternative, see:
Printing a Quantity of a Label
at:
http://allenbrowne.com/ser-39.html

That is one slick solution. Simple. Pragmatic. Bulletproof for all
practical purposes. I wish I'd thought of it.

[Wayne]

w_a_n_n_a_l_l_-@-_s_b_c_g_l_o_b_a_l._n_e_t wrote:

On 13-Jun-2006, "Allen Browne" <Al*********@SeeSig.Invalid> wrote:

For details and an alternative, see:
Printing a Quantity of a Label
at:
http://allenbrowne.com/ser-39.html

That is one slick solution. Simple. Pragmatic. Bulletproof for all
practical purposes. I wish I'd thought of it.

[Wayne]

Having trouble replying. Thanks for the above. I did add a report
header and initialised the label count there and it is now fine. Page
Preview is not wysiwyg - how could I have known this in advance?
Cheers