INF: Memo & OLE Objects Unavailable in Mailing Label Wizard

Article ID: Q142232
Creation Date: 08-JAN-1996
Revision Date: 20-SEP-1996

The information in this article applies to:

Microsoft Access versions 2.0, 7.0

SYMPTOMS

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

When you create a report using the Mailing Label Wizard in Microsoft Access version 2.0 or the Label Wizard in Microsoft Access for Windows 95 version 7.0, Memo fields and OLE Object fields contained in the table or query that the report is based on are not available in the wizard's Available Fields list.

CAUSE

Because a Memo field may contain large amounts of text that may not fit on a mailing label and because an OLE Object field may contain information not appropriate for a mailing label, the wizard ignores these fields.

RESOLUTION

There is no workaround for OLE Object fields. To work around this behavior for Memo fields, you can create a query based on the table or query and use an expression in the query that includes the Memo field. For an example of how to do so, follow these steps:

Open the sample database Northwind.mdb (or NWIND.MDB in version 2.0).

Create a new query named Query1 based on the Categories table. Drag the following two fields from the Categories box to the QBE grid:

      Field: CategoryID
      Field: CategoryName

    NOTE: In version 2.0, there is a space in the Category ID and the
    Category Name fields.

In the third column of row one, type the following expression:
```
      Field: Expr1:""&[Description]
```
Note that this expression references the Categories table's Description field, which is a Memo field.
In Microsoft Access 7.0, use the Label Wizard to create a new report based on the Query1 query. In the Label Wizard box, click Next twice. Note that under Available Fields, the Expr1 field is available, and you can add it to the mailing label.
In Microsoft Access 2.0, use the Mailing Label Wizard to create a new report based on the Query1 query. Note that under Available Fields, the Expr1 field is available, and you can add it to the mailing label.

STATUS

This behavior is by design.

MORE INFORMATION

Steps to Reproduce Behavior

Open the sample database Northwind.mdb (or NWIND.MDB in version 2.0).
In Microsoft Access 7.0, use the Label Wizard to create a new report based on the Categories table. In the Label Wizard box, click Next twice. Note that under Available Fields, you see only the CategoryID and CategoryName fields, but not the Category table's Description field, which is a Memo field, or the table's Picture field, which is an OLE Object field.
In Microsoft Access 2.0, use the Mailing Label Wizard to create a new report based on the Categories table. Note that under Available Fields, you see only the Category ID and Category Name fields, but not the Category table's Description field, which is a Memo field, or the table's Picture field, which is an OLE Object.

THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.