Microsoft KB Archive/287475

= ACC2002: Text in the Expression Builder Is Not Wrapped as Expected =

Article ID: 287475

Article Last Modified on 11/5/2003

-

APPLIES TO


 * Microsoft Access 2002 Standard Edition

-



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.



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.

