Database localization

Choosing the Database Localization preference item lets you change some data entry fields on Otobase forms to automatically reflect the customary formats in your country. If you would like to use U.S. formats for zip code, telephone and date, click "Database located in USA." Otherwise, modify formats according to the directions below.

With Database localization selected on the Preferences form, make sure "Database located in USA" is not checked.

Click in the box next to the field you would like to automatically format.

Use the following characters to set entry formats for postal code and telephone number:

"$" to stand for a number

"@" to stand for a letter

"?" to stand for a letter or number.

Type in any fixed characters that you wish to appear, such as parentheses, hyphens or spaces.

Click next to the date format you wish to appear on your forms.
The various data entry forms now reflect the telephone number, postal code or date formats you have chosen.

If the postal code in your country has an optional part (for example, the last four digits in the U.S. zip code), you can use the "Zip code format suppression" box to override this part of the code on data entry forms. (You can always override the autoformat function by selecting Format On/Off). By entering zeros in place of the optional numbers here, you are telling Otobase to allow data entry personnel to skip this part of the postal code and suppress the printing of "-0000."