ACC2000: You Are Prompted to Enter a Parameter Value for the Trim Function While Previewing a Mailing Label Report (283166)


The information in this article applies to:

  • Microsoft Access 2000
This article was previously published under Q283166
Moderate: Requires basic macro, coding, and interoperability skills.

This article applies only to a Microsoft Access database (.mdb).

SYMPTOMS

If you originally created a mailing label report with the wizard in Microsoft Access 95 or earlier, and you then open that database in Microsoft Access 2000, when you run the mailing label report, you may see the parameter value dialog box and be prompted to enter a value for the Trim function.

NOTE: This behavior also occurs in Access 2002.

CAUSE

There is a reference missing that was necessary in Microsoft Access 95 or earlier but that is not necessary in Microsoft Access 2000.

RESOLUTION

There are two resolutions for this behavior. If the first resolution does not solve the problem, continue to the second:

  1. Clear the missing references in the Visual Basic Editor. To do so, follow these steps:
    1. Double-click the mailing label report to open it.
    2. On the View menu, click Code to open the Visual Basic Editor.
    3. In the Visual Basic Editor, click References on the Tools menu.
    4. In the References dialog box, click to clear any reference that begins with the word "MISSING," and then click OK.
    5. On the File menu, click Save, and then click Close and Return to Microsoft Access.
    6. Click to select the report, and then click the Print Preview button on the Standard toolbar.
    7. If you still get the parameter value dialog box, proceed to the second solution.
  2. Import all the objects from the Access 95 database into a new Access 2000 database. To do so, follow these steps:
    1. On the File menu, click New.
    2. Click Database, and then click OK.
    3. Type a name for the new database, and then click OK.
    4. On the File menu, point to Get External Data, and then click Import.
    5. In the Import dialog box, click the Access 95 database, and then click OK.
    6. In the Import Objects dialog box, click to highlight the objects that you want to import.

      NOTE: Be sure to click each tab and select all the items that you want to import.
    7. After you have highlighted all the objects that you want to import, click OK. You should see the items appear in the Access 2000 database.
    8. Click the Print Preview button on the Standard toolbar. The report should print preview properly.

MORE INFORMATION

Steps to Reproduce the Behavior

  1. Use the Label Wizard to create a mailing label report in Access 95 or earlier.

    NOTE: The Label Wizard is called the Mailing Label Report Wizard in Access 2.0.
  2. Open the database in Access 2000, and then click OK to convert the database when you are prompted.
  3. Open the mailing label report in print preview.

REFERENCES

Modification Type:MajorLast Reviewed:6/29/2004
Keywords:kbprb KB283166
©2004 Microsoft Corporation. All rights reserved.