I'm using the Label Wizard to create mailing labels for Avery 5160. The
labels are fine at initial set up -- three columns with ten rows per page.
There's no image or any special customized formatting. It's just a plain set
of labels that's 1" x 2 5/8".
The problem I'm having is that when I run a macro to generate these labels,
the system defaults it to a single column. Can someone please tell me what's
causing this and how I can prevent it from happening? The end-users don't
know Access and I can't expect them to be able to recreate this report each
time the system changes its settings.
Thanks,
Nyla
Do you have all the service packs installed? This is a common issue with
Access 2000 without service packs and/or name autocorrect turned on.

Signature
Duane Hookom
MS Access MVP
--
> I'm using the Label Wizard to create mailing labels for Avery 5160. The
> labels are fine at initial set up -- three columns with ten rows per page.
[quoted text clipped - 13 lines]
> Thanks,
> Nyla
Nyla K - 10 Oct 2005 18:29 GMT
I don't think so. What service pack should I install that will correct this
problem? Also, is it free?
Thanks.
> Do you have all the service packs installed? This is a common issue with
> Access 2000 without service packs and/or name autocorrect turned on.
[quoted text clipped - 16 lines]
> > Thanks,
> > Nyla
Duane Hookom - 10 Oct 2005 21:21 GMT
It's free at http://office.microsoft.com/en-us/officeupdate/default.aspx.
Also note my suggestion about turning off all Name Autocorrect options.

Signature
Duane Hookom
MS Access MVP
--
>I don't think so. What service pack should I install that will correct
>this
[quoted text clipped - 26 lines]
>> > Thanks,
>> > Nyla
Nyla K - 10 Oct 2005 22:25 GMT
Thank you. I will try your suggestions.
> It's free at http://office.microsoft.com/en-us/officeupdate/default.aspx.
> Also note my suggestion about turning off all Name Autocorrect options.
[quoted text clipped - 29 lines]
> >> > Thanks,
> >> > Nyla