Microsoft KB Archive/223243

= ACC2000: Results of Expression and Sorting on a Data Access Page May Be Different in Access and Internet Explorer =

Article ID: 223243

Article Last Modified on 1/26/2005

-

APPLIES TO


 * Microsoft Access 2000 Standard Edition

-



This article was previously published under Q223243



Moderate: Requires basic macro, coding, and interoperability skills.

This article applies only to a Microsoft Access project (.adp).



SYMPTOMS
Expressions that compare text strings on a data access page may produce different results depending on whether you view the page in Microsoft Access or in Microsoft Internet Explorer. The sort order may also be different.



CAUSE
The result of the comparison is determined by the Locale ID. When you view a page in Internet Explorer, the Locale ID is set to a different value than it is in Access.



STATUS
Microsoft has confirmed that this is a problem in Microsoft Access 2000.



Steps to Reproduce Problem
 Close any open database, and then click New on the File menu. In the New dialog box, click the General tab. Click Data Access Page, and then click OK. In the New Data Access Page dialog box, click Design View, and then click OK. On the Connection tab of the Data Link Properties dialog box, fill in the server name, the user name, the password, and the database boxes with the appropriate settings for a Microsoft Access project or SQL Server database. Click OK. Add a field from any table.</li> In the toolbox, click the Text Box tool, and then draw a text box on the page.</li> If the Properties window is not displayed, on the View menu, click Properties.</li> Set the ControlSource property of the text box as follows:

Expr1: iif('a'<'B','True','False')

</li> On the File menu, click Save.</li> In the File name box, type dapExprProb.htm, and then click Save.</li> On the View menu, click Page View.

Note that the text box that you added in step 6 contains the word "True."</li> On the File menu, click Close.</li> Open the dapExprProb.htm file in Internet Explorer.

Note that the text box that you added in step 6 contains the word "False."</li></ol>

Additional query words: pra text

Keywords: kbbug kbdap kbpending KB223243

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.