Microsoft KB Archive/131171

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

Article ID: 131171

Article Last Modified on 1/19/2007

-

APPLIES TO


 * Microsoft Works 6.0
 * Microsoft Works 2000 Standard Edition
 * Microsoft Works 3.0 Standard Edition
 * Microsoft Works 4.0 Standard Edition
 * Microsoft Works 4.5 Standard Edition

-



This article was previously published under Q131171



SUMMARY
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.



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:  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

- or -

=UPPER

where  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.</li> On the Edit menu, click Paste.</li> Click the heading of the field that contains the UPPER or PROPER function to select the entire column.</li>  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. </li></ol>

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.

Additional query words: 3.00 4.00 4.00a 4.50 w_works works2k works6 proper upper lower case uppercase lowercase initcaps

Keywords: kbhowto kbui KB131171

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.