Microsoft Knowledge Base Article
This article contents is Microsoft Copyrighted material.
©2005-©2007 Microsoft Corporation. All rights reserved.
Terms
of Use |
Trademarks
Article ID: 311114 - Last Review: September 25, 2003 - Revision: 3.0
ACC2002: Expression Builder Causes Error with Strings That Are More Than 1,023 Characters Long
This article was previously published under Q311114
Novice: Requires knowledge of the user interface on single-user computers.
This article applies only to a Microsoft Access database (.mdb).
For a Microsoft Access 2000 version of this article, see
305532Â
(http://kbalertz.com/Feedback.aspx?kbNumber=305532/EN-US/
)
.
You are using the Expression Builder to create an expression for an event property. The expression that you create is between 1,024 and 2,048 characters long. When you then do one of the following
- you click OK in the Expression Builder
-or-
- you move the focus from the event property box after you click OK
you receive the following error message:
An expression can't be longer than 2,048 characters.
The Microsoft Access Help files do not indicate that there is a limit on how long an expression can be. This limit is also not consistent with the limit of the object receiving the expression.
To work around this problem, limit expressions that you create in the Expression Builder to 1,023 or fewer characters.
Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.
An event property can handle a maximum string size of 2,048 bytes. However, Access stores the string characters in a two-byte Unicode format. Therefore, the effective maximum length of an expression is 1,024 characters.
Steps to Reproduce the Behavior
- Start Microsoft Access.
- Open the sample database Northwind.mdb.
- In the Database window, click Forms under Objects, and then click New.
- In the New Form dialog box, click Design View, and then click OK.
- Right-click in the detail section of the new form, and then click Build Event.
- In the Choose Builder dialog box, click Expression Builder, and then click OK.
- In the Expression Builder, create any expression that is at least 1,024 characters long.
- Click OK to close the Expression Builder. Note that you receive the error message that is mentioned in the "Symptoms" section of this article.
APPLIES TO
- Microsoft Access 2002 Standard Edition
| kberrmsg kbbug kbnofix KB311114 |
Community Feedback System
Very often, it takes hours to solve a problem. Very often, you've looked high
and low, and have tried a lot of solutions. When you finally found it, chances
are, it was because someone else helped you. Here's your chance to give back.
Use our community feedback tool to let others know what worked for you and what
didn't.
Please also understand that the community feedback system is not warranted to be
correct, it's simply a system that we've built to let people try and help each
other. If something in a feedback response doesn't make sense to you, or you're
not comfortable making changes that the feedback talks about (like registry
edits), please consult a professional.
Thank you for using kbAlertz.com Feedback System.
-- Scott Cate