UPPERCASE all field in the Form.

[sigh]

Hi,
Is't any easy way to set as all the fields in the form
to automatic convert to UPPERCASE as the user type. Do I
have to program the code to covert to uppercase each field
or all fields at the same time?
Any help would be very appreciated.

 

[tina]

paste the following code into a module

Public Function AllCAPS()

If IsNull(Screen.ActiveControl) Then
Exit Function
Else
Screen.ActiveControl = StrConv
(Screen.ActiveControl, vbUpperCase)
End If

End Function

capitalizes every letter in the string in the form control.
call this function in an event procedure, or run it
directly from the After Update or On Exit event line in
the control properties window, as =ALLCAPS()
using this function will actually change the data entered
in the control.

hth