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

View products that this article applies to.

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.

Back to the top

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.

Back to the top

STATUS

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

Back to the top

MORE INFORMATION

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.
In the toolbox, click the Text Box tool, and then draw a text box on the page.
If the Properties window is not displayed, on the View menu, click Properties.
Set the ControlSource property of the text box as follows:
Expr1: iif('a'<'B','True','False')
On the File menu, click Save.
In the File name box, type dapExprProb.htm, and then click Save.
On the View menu, click Page View.

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

Note that the text box that you added in step 6 contains the word "False."