Use this form to choose and implement case rules.
The underlying table and field are displayed in the form's caption. The form lists all data for the given Source Field. You can scroll through the data to determine if case has been consistently entered for this field. In this example, upper and lower case are inconsistently mixed. Queries specifying criteria using this field will not be evaluated after migration as they were in the Access application.
You can choose to apply Lower or Upper case rules, or you can use a standard search and replace dialog to apply a case rule of your choosing, e.g., capitalize the first letter and force the remaining characters to lower case.
You can also elect to generate DBMS triggers that enforce the case rule specified for all inserts and updates to this field. This ensures that the case rule is enforced when new data is entered or changed and is the default setting. If you choose to search and replace data, you should choose not to generate triggers. Note that triggers cannot be created for Memo fields since the UPPER and LOWER built-in functions are not permitted on LOB columns. You may wish to change the data type conversion to VARCHAR(4000) for Memo fields in these instances.
Note that if the Update Query Criteria option is set to Yes, queries specifying this field in expressions are modified to be consistent with the case rule specified only when the Lower Case or Upper Case buttons are pressed; no action is taken when the manual search and replace option is chosen. For example, if the Lower Case button is pressed, all text constants in relevant query expressions will be converted to lower case.