Label Wizard - Loses margins

[Andrea]

I've run into a random problem with creating mailing labels through
access, and I can't seem to find a solution for it. I'm running
Access 2000 on Windows 2000. I'm using the label wizard to create
Avery 5160 mailing labels. When I first create the labels they look
fine and will print out fine. But at some random interval, they lose
their formatting. Instead of going left-to-right, top-to-bottom, all
of the labels are printed straight down the leftmost column. I am not
making any changes to the labels once the wizard has created them. I
find that if I re-create the labels, they will work for a while, but
then lose the formatting again. Does anyone know what might be
causing this? I can't seem to find an answer on google so I'm not
sure if it's access or me. (My money is on me) Any help would be
greatly appreciated.

Sincerely,
Andrea

[Fred Zuckerman]

The label wizard that you've used probably created a report that you've
saved so as to run it again as needed.
A2k has a known bug where reports lose their margin settings if the
"Auto-Correct" settings are enabled. If you turn those settings "off" and
fix the margins (or run the wizard again), then you should be ok.

The settings are in Tools -> Options -> General -> Name AutoCorrect

Good Luck,
Fred Zuckerman
San Diego, CA, USA
"Andrea" <cl****@healingamerica.com> wrote in message
news:17*************************@posting.google.co m...

I've run into a random problem with creating mailing labels through
access, and I can't seem to find a solution for it. I'm running
Access 2000 on Windows 2000. I'm using the label wizard to create
Avery 5160 mailing labels. When I first create the labels they look
fine and will print out fine. But at some random interval, they lose
their formatting. Instead of going left-to-right, top-to-bottom, all
of the labels are printed straight down the leftmost column. I am not
making any changes to the labels once the wizard has created them. I
find that if I re-create the labels, they will work for a while, but
then lose the formatting again. Does anyone know what might be
causing this? I can't seem to find an answer on google so I'm not
sure if it's access or me. (My money is on me) Any help would be
greatly appreciated.

Sincerely,
Andrea

[Fletcher Arnold]

"Andrea" <cl****@healingamerica.com> wrote in message
news:17*************************@posting.google.co m...

I've run into a random problem with creating mailing labels through
access, and I can't seem to find a solution for it. I'm running
Access 2000 on Windows 2000. I'm using the label wizard to create
Avery 5160 mailing labels. When I first create the labels they look
fine and will print out fine. But at some random interval, they lose
their formatting. Instead of going left-to-right, top-to-bottom, all
of the labels are printed straight down the leftmost column. I am not
making any changes to the labels once the wizard has created them. I
find that if I re-create the labels, they will work for a while, but
then lose the formatting again. Does anyone know what might be
causing this? I can't seem to find an answer on google so I'm not
sure if it's access or me. (My money is on me) Any help would be
greatly appreciated.

Sincerely,
Andrea

I guess this will be a problem with all reports - not just wizard-generated
labels. Have you updated your office installation? In the meantime
re-set the page setup, then Tools>Options>General Tab and switch off the
name auto-correct feature.
See the following for further details:
http://support.microsoft.com/default...b;en-us;240826

Fletcher

[MacDermott]

It sounds as if you may be running Access 2000 without SP-1.

While that configuration may occasionally function adequately in running
applications, IMHO it should never be used for any kind of development.
Get the Service Pack.

HTH
- Turtle

"Andrea" <cl****@healingamerica.com> wrote in message
news:17*************************@posting.google.co m...

I've run into a random problem with creating mailing labels through
access, and I can't seem to find a solution for it. I'm running
Access 2000 on Windows 2000. I'm using the label wizard to create
Avery 5160 mailing labels. When I first create the labels they look
fine and will print out fine. But at some random interval, they lose
their formatting. Instead of going left-to-right, top-to-bottom, all
of the labels are printed straight down the leftmost column. I am not
making any changes to the labels once the wizard has created them. I
find that if I re-create the labels, they will work for a while, but
then lose the formatting again. Does anyone know what might be
causing this? I can't seem to find an answer on google so I'm not
sure if it's access or me. (My money is on me) Any help would be
greatly appreciated.

Sincerely,
Andrea