Registrations are now open. Join us today!
There is still a lot of work to do on the wiki yet! More information about editing can be found here.
Already have an account?

Microsoft KB Archive/170982

From BetaArchive Wiki

Article ID: 170982

Article Last Modified on 1/20/2007


  • Microsoft Access 97 Standard Edition

This article was previously published under Q170982

Novice: Requires knowledge of the user interface on single-user computers.


When you use the Label Wizard to create labels in Microsoft Access, you are not able to move field names to the next line of the label by pressing ENTER or ALT+ENTER.


To move a field name to the next line of the label in the wizard, you need to cut and then paste it.


This behavior is by design.


Steps to Reproduce Behavior

  1. Open the sample database Northwind.mdb.
  2. Use the Label Wizard to create a new report based on the Customers table.
  3. On the first screen of the wizard accept the defaults, and then click Next twice.
  4. On the screen that asks "What would you like on your mailing labels?" in the Available Fields: list box, double-click CustomerID and CompanyName.
  5. In the Prototype label list box, add three spaces between CustomerID and CompanyName.
  6. While the mouse pointer is between CustomerID and CompanyName, press ENTER or ALT+ENTER to try to place CompanyName on the next line.

Note that the CompanyName field cannot be moved to the next line by pressing ENTER or ALT+ENTER.


For more information about using the Label Wizard, search the Help Index for "Label wizard," and then "Create mailing and other types of labels," or ask the Microsoft Access 97 Office Assistant.

Keywords: kbprb KB170982