lower case

[kitty77]

I have a form that has a field (name) that has all CAPS. How can I create a command button (vba) that will convert that field to lower case?

Thanks.

 

[MajP]

Something like

Me.ControlName = strConv(me.controlname, vblowercase)

StrConv function (Visual Basic for Applications)

Office VBA reference topic

learn.microsoft.com

 

[Galaxiom]

Another alternative might be an Input Mask.

Control data entry formats with input masks - Microsoft Support

Learn how to add input masks in Access to table fields, queries, and to form and report controls to help people entering data.

support.microsoft.com

 

[kitty77]

Something like

Me.ControlName = strConv(me.controlname, vblowercase)

https://learn.microsoft.com/en-us/o...nce/user-interface-help/strconv-function[/URL

http://

 

[kitty77]

Is there any way to make the the first letter of each word CAP and the rest lower case?
Example: SUNSHINE STRORAGE SYSTEMS, would be Sunshine Storage Systems

Thanks.

 

[MajP]

Read the link there are other conversions

Me.ControlName = strConv(me.controlname, vbPropercase)

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 a string to uppercase.
vbWide	4	Converts narrow (single-byte) characters in a string to wide (double-byte) characters.
vbNarrow	8	Converts wide (double-byte) characters in a string to narrow (single-byte) characters.
vbKatakana	16	Converts Hiragana characters in a string to Katakana characters.
vbHiragana	32	Converts Katakana characters in a 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.)

 

[GPGeorge]

Is there any way to make the the first letter of each word CAP and the rest lower case?
Example: SUNSHINE STRORAGE SYSTEMS, would be Sunshine Storage Systems

Thanks.

No automated process is going to be perfect. What you refer to here, i.e. Proper Case, won't account for names like "The Franklin O'Donohue Corp" and others of that type. The final step will always involve the use of the basic Human Eyeball.

 

[NauticalGent]

The final step will always involve the use of the basic Human Eyeball.

Aye, but that way lies madness...