Works: How to Use UPPPER and PROPER Functions to Change Capitalization of Text in a Database Field

MORE INFORMATION

To use a function to change the capitalization of text in a Works Database field, use the UPPER() function to capitalize all of the letters in the field, or use the PROPER() function to capitalize the initial letter in each word in the field.

To do this:

1. On the View menu in Works Database, click List.
2. Click the heading of a field that contains text that you want to capitalize to select the entire column.
3. Insert a new field. To do this, use the appropriate method for your version of Microsoft Works:

   Works 4.0 or later

   On the Record menu, click Insert Field, click After and accept the default field name. Click Add and click Done.

   Works 3.0

   On the Insert menu, click Record/Field.
4. In the first record of the new field, type the appropriate line for the function that you want to use:

   =UPPER(field)

   - or -

   =UPPER(field)

   where field is the name of the field that you selected in step 2.
5. Click the heading of the new field to select the entire column.
6. On the Edit menu, click Copy.
7. Click the heading of the field that you selected in step 2 to select the entire column.
8. On the Edit menu, click Paste.
9. Click the heading of the field that contains the UPPER or PROPER() function to select the entire column.
10. Delete the field that contains the UPPER() or PROPER() function. To do this, use the appropriate method for your version of Works:

    Works 4.0 or later

    On the Record menu, click Delete Field, and then click OK.

    Works 3.0

    On the Insert menu, click Delete Record/Field.

The UPPER() and PROPER() functions require text values. If you attempt to use one of these functions to process a blank cell or a non-text value such as a time or date, the function returns an ERR value.

For more information about these functions, please see Appendix A of your "Microsoft Works User's Guide" (version 3.0) or Works online Help.