Query Design view displays the query in a layout consistent with the current user interface language.
All Text and Memo fields are assigned General alignment and Context reading order. Visual layout adjusts automatically based on the language of the first character entered in a field. Alignment can be overridden by creating a custom format by using the format control character, the exclamation point (!), in the Format property in the query's property sheet. Reading order, however, is fixed.
Access provides right-to-left support for many of the other query features available in Design view. For example, if you choose to design a crosstab query, you have the same ability to use the query's property sheet to change the view direction of the crosstab query you're creating.
The direction of the data, description fields, and other window components will be right-to-left or left-to-right depending on the query orientation you choose in Design view.
The Orientation property allows you to change the overall right-to-left or left-to-right direction of the query in Datasheet view, regardless of the Default direction setting on the International tab in the Options dialog box (Tools menu).
Other query design considerations
You can use right-to-left or mixed right-to-left and left-to-right text to name many of the objects you create. You can:
- Provide bidirectional text in names given to tables you create with a make-table query.
- Select tables with right-to-left or bidirectional text names when you add data to a table by using an append query.
- Name query parameters with right-to-left or bidirectional text in a parameter query.
The editor displays SQL statements in an overall left-to-right direction regardless of the user interface language or chosen query view direction.
Important Dates in SQL statements are always displayed as Gregorian calendar values, regardless of database calendar chosen. If you change a date in a SQL statement, the new value must be a Gregorian date.