This article describes how to use the UPPER() and PROPER() text functions in Microsoft Works to change the capitalization of text in a Works Database field.
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:
- On the View menu in Works Database, click List.
- Click the heading of a field that contains text that you want to
capitalize to select the entire column.
- 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.
- 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.
- Click the heading of the new field to select the entire column.
- On the Edit menu, click Copy.
- Click the heading of the field that you selected in step 2 to select
the entire column.
- On the Edit menu, click Paste.
- Click the heading of the field that contains the UPPER or PROPER()
function to select the entire column.
- 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.
Back to the top
