>

CollatingOrder Property

Applies To

Database Object, Field Object.

Description

Returns a value that specifies the sequence of the sort order in text for string comparison or sorting. This property setting is read-only.

Return Values

The possible return values are:

Values

Description

dbSortGeneral

Use the General (English, French, German, Portuguese, Italian, and Modern Spanish) sort order.

dbSortArabic

Use the Arabic sort order.

dbSortCyrillic

Use the Russian sort order.

dbSortCzech

Use the Czech sort order.

dbSortDutch

Use the Dutch sort order.

dbSortGreek

Use the Greek sort order.

dbSortHebrew

Use the Hebrew sort order.

dbSortHungarian

Use the Hungarian sort order.

dbSortIcelandic

Use the Icelandic sort order.

dbSortJapanese

Use the Japanese sort order.

dbSortNeutral

Use the neutral sort order.

dbSortNorwdan

Use the Norwegian or Danish sort order.

dbSortPDXIntl

Use the Paradox International sort order.

dbSortPDXNor

Use the Paradox Norwegian or Danish sort order.

dbSortPDXSwe

Use the Paradox Swedish or Finnish sort order.

dbSortPolish

Use the Polish sort order.

dbSortSpanish

Use the Spanish sort order.

dbSortSwedFin

Use the Swedish or Finnish sort order.

dbSortTurkish

Use the Turkish sort order.

dbSortUndefined

The sort order is undefined or unknown.


Remarks

These constants are listed in the Data Access (DAO) object library in the Object Browser.

For a Field object, the CollatingOrder property depends on the object that contains the Fields collection, as shown in the following table.

Object appended to

Usage

Index

Not supported

QueryDef

Read-only

Recordset

Read-only

Relation

Not supported

TableDef

Read only


The CollatingOrder property setting corresponds to the locale argument of the CreateDatabase method when the database was created or the CompactDatabase method when the database was most recently compacted.

Check the CollatingOrder property setting of a Database or Field object to find out the string comparison method for the database or field. You can set the CollatingOrder property of a new Field object if you want the setting of the Field object to differ from that of the Database object that contains it.

The CollatingOrder and Attributes property settings of a Field object in a Fields collection of an Index object together determine the sequence and direction of the sort order in an index. However, you can't set a collating order for an individual index — only for an entire table.

See Also

Attributes Property.

Example (Microsoft Access)

The following example checks the CollatingOrder property for the current database.


Sub SetSortOrder()
    Dim dbs As Database

    ' Return Database variable that points to current database.
    Set dbs = CurrentDb
    ' Check CollatingOrder property for database.
    Debug.Print dbs.CollatingOrder
End Sub