ACC2002: Text in the Expression Builder Is Not Wrapped as Expected (287475)


The information in this article applies to:

  • Microsoft Access 2002
This article was previously published under Q287475
Novice: Requires knowledge of the user interface on single-user computers.

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

SYMPTOMS

In Microsoft Access, when you use the Expression Builder to create an expression that is longer than the width of the expression box, the text of the expression is not wrapped to the next line as expected. Instead, the expression continues in one long line that may extend beyond the left and right borders of the expression box.

RESOLUTION

To work around this issue, use one of the following methods:
  • If possible, enlarge the Expression Builder window until you can see the entire expression. -or-

  • If the expression is longer than the Expression Builder window can accommodate, use the left and right arrows on the keyboard to move the insertion point to the left or the right to view all portions of the expression.

STATUS

Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.

MORE INFORMATION

Steps to Reproduce the Problem

CAUTION: If you follow the steps in this example, you modify the sample database Northwind.mdb. You may want to back up the Northwind.mdb file and follow these steps on a copy of the database.

  1. Start Access and open the sample database Northwind.mdb.
  2. In the Database window, under Objects, click Tables, click Categories, and then click Design.
  3. Under Field Name, click the CategoryName field, and then under Field Properties, click the Default Value box.
  4. Click the Build button (...) to the right of the Default Value box to open the Expression Builder.
  5. In the folder list on the lower left, double-click Functions, and then click Built-In Functions.
  6. In the list of functions on the right, scroll down to Command, and then select it.
  7. Click the Paste button several times to insert the function in the expression box.

    NOTE: The Paste button is located immediately above the list of functions. Notice that the line of text in the expression box is not wrapped as expected when it reaches the right border of the box.

REFERENCES

For more information about creating expressions using the Expression Builder, click Microsoft Access Help on the Help menu, type about the expression builder in the Office Assistant or the Answer Wizard, and then click Search to view the topic.
Modification Type:MajorLast Reviewed:11/5/2003
Keywords:kbbug kbpending KB287475
©2003 Microsoft Corporation. All rights reserved.