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


The information in this article applies to:

  • Microsoft Access 2000
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.

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).
Modification Type:MajorLast Reviewed:6/24/2004
Keywords:kbbug kbDAP kbnofix KB225933
©2004 Microsoft Corporation. All rights reserved.