473,671 Members | 2,331 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Label Wizard - Loses margins

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
Nov 12 '05 #1
3 2946
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****@healing america.com> wrote in message
news:17******** *************** **@posting.goog le.com...
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

Nov 12 '05 #2
"Andrea" <cl****@healing america.com> wrote in message
news:17******** *************** **@posting.goog le.com...
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>G eneral 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


Nov 12 '05 #3
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****@healing america.com> wrote in message
news:17******** *************** **@posting.goog le.com...
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

Nov 12 '05 #4

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

3
5797
by: Serious_Practitioner | last post by:
Hello, all - I would like to produce Avery labels, #5931, from a database I've built for a client. I can't seem to find this Avery number in the list of labels that pops up when one uses the label wizard. This is a label for CD and DVD media - Word 2002 has the template built in, but Access 2002 doesn't seem to. Does this mean I have to use a "mail-merge" type activity, or can I get Access to use the Word template somehow?
3
1878
by: Robert | last post by:
Sorry for posting such an easy question but a while ago I created some address labels using the label wizard in Access. Now I can't seem to find it! Can someone point me to the label wizard? I need to make some more. Robert
2
1686
by: john young | last post by:
when settingup a label report in access using the wizard the resulting previw and print out is not as it should be .... example is using Avery labels(or any other). 24 to page ...3col by 8 rows... only 7 rows display.... Q. 1.. how can this be overcome to display correct number of rows..... and 2.. if one edits the report/label to change to custom .the latter rows of address labels 'creep' up the page so last row is printed on row...
6
9763
by: Ian | last post by:
I am trying to get MS Access 2000 to print names and addresses onto a Dymo 400 label printer, I have set the Access Report to automatically select the correct printer, then select the label size of “99012 Large Address”. This works fine but when I move my database to another PC (with identical Dymo printer and drivers) the report defaults to the correct printer but does not select the label “99012 Large Address”. On different PC’s it...
0
8473
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
8911
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
8819
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
0
8667
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
7428
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
1
6222
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
4222
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
1
2808
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
2
1806
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.