Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

ACC2000: Orientation of a Control on a Data Access Page Changes When You Modify the Dir Property


View products that this article applies to.

This article was previously published under Q225933
This article applies to a Microsoft Access database (.mdb) and to a Microsoft Access project (.adp).

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

↑ Back to the top


Symptoms

You can use the Dir property to specify or to determine the view orientation for information within a control. The Dir property directly influences how information within a control is displayed. However, when you change the Dir property of a data access page, the orientation of the control itself is changed, not just the information within the control.

↑ Back to the top


More information

Steps to Reproduce the Behavior

1.Open any database.
2.Create a new, unbound data access page in Design view.
3.On the Insert menu, click ActiveX Control.
4.In the Insert ActiveX Control dialog box, click the Microsoft Office Spreadsheet 9.0 control, and then click OK.
5.View the page in Page view, and note the position of the spreadsheet control.
6.Switch back to Design view, and on the Tools menu, point to Macro, and then click Microsoft Script Editor.
7.On the second line of the script, which begins with <HTML XMLNS:, add DIR=RTL after HTML so that the beginning of this line reads <HTML DIR=RTL XMLNS: .
8.Save the page, and then view it in Page view. Note that the orientation of the entire spreadsheet control has changed.
NOTE: This is not specific to the spreadsheet control; you can reproduce this behavior with other controls.

IMPORTANT: Microsoft Support Professionals do not support the modification of existing HTML and script that is found within data access pages. Instead, use other Microsoft Access or Microsoft Office components to modify properties. For example, to have the data access page and its controls respond to page-level changes as they are made, use the Data Access Page property sheet or the Microsoft Script Editor Properties window to change property settings (such as BackgroundColor, bgColor, Dir, and so on).

↑ Back to the top


Keywords: KB225933, kbdap, kbnofix, kbbug

↑ Back to the top

Article Info
Article ID : 225933
Revision : 2
Created on : 6/24/2004
Published on : 6/24/2004
Exists online : False
Views : 333