Proper case formatting? Proper case formatting? straybullet (IS/IT--Management) (OP) 23 Sep 03 16:35 I am familiar with proper case formatting of text in Excel - however, in Access - it seems to be possible to either have all upper or lower case. Any suggestions? RE: Proper case formatting? mph1 (TechnicalUser) 23 Sep 03 16:59 You can check help for upper and lower case functions. In addition, if you only want the output to appear in upper case, put the > symbol in the format, in desing veiw, of the field. An investment in knowledge always pays the best dividends.by Benjamin Franklin RE: Proper case formatting? ptpaton (IS/IT--Management) 23 Sep 03 18:15 You can use the StrConv function to help control the case. StrConv([YourField],vbProperCase)This will convert your string to Title case. There are a few others. Here's a list from the help file in Access:vbUpperCase 1 Converts the string to uppercase characters. vbLowerCase 2 Converts the string to lowercase characters. vbProperCase 3 Converts the first letter of every word in string to uppercase. vbWide* 4* Converts narrow (single-byte) characters in string to wide (double-byte) characters. vbNarrow* 8* Converts wide (double-byte) characters in string to narrow (single-byte) characters. vbKatakana** 16** Converts Hiragana characters in string to Katakana characters. vbHiragana** 32** Converts Katakana characters in string to Hiragana characters. vbUnicode 64 Converts the string to Unicode using the default code page of the system. (Not available on the Macintosh.) vbFromUnicode 128 Converts the string from Unicode to the default code page of the system. (Not available on the Macintosh.) Should work for you. Let me know if not.Patrick RE: Proper case formatting? straybullet (IS/IT--Management) (OP) 24 Sep 03 10:16 Looks great - thank you - however, where should I use this? RE: Proper case formatting? ptpaton (IS/IT--Management) 24 Sep 03 11:21 You can use StrConv either in a formula for the control source of a text box ControlSource: =StrConv([YourField],vbProperCase)Or in the field of a queryYourField1: StrConv([YourField],vbProperCase)I generally do formatting stuff like this at the form or report level, so as not to alter the data. If you change the format at the query level, you can run into some criteria problems later.Good luck! -PatrickNine times out of ten, the simplest solution is the best one. RE: Proper case formatting? Gnism (TechnicalUser) 24 Sep 03 13:35 Patrick’s is right, however I had problems using it in a query as he suggested. I found this to work in that scenario - YourField1: StrConv([YourField],3).