Microsoft KB Archive/225933

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

Article ID: 225933

Article Last Modified on 6/24/2004

-

APPLIES TO


 * Microsoft Access 2000 Standard Edition

-



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.



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.



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).

Additional query words: prb dap position

Keywords: kbbug kbnofix kbdap KB225933

-

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

© Microsoft Corporation. All rights reserved.