I find UPPER CASE to be very distracting and annoying in any data in my database. I found this code at a Google-archived newsgroup posting. It automatically converts the text in your form to the "proper name" format--that is, OPEN NEW PROJECT becomes Open New Project.
The code, which is generally used as an "after update" event:
|
Private Sub packaging_instructions_AfterUpdate() Dim stNew As String stNew = StrConv(Me.packaging_instructions, vbProperCase) Me.packaging_instructions = stNew End Sub |
In the above example, the field name being converted is called packaging_instructions. Simply substitute the correct field name from your form.