Capslock

[JoeAcess]

Hi everyone


I have a form in which i want all the enteries to be made in caps... Can i Make sure all the fields is entered in caps lock. How is this done?

 

[wazz]

you can use the UCase function to ensure all 'caps'. the On Exit event of your control might do it for you.

 

[JoeAcess]

how do i code it under "on exit"

 

[wazz]

something like:

Private Sub textbox1_Exit(Cancel As Integer)
    Me.textbox1 = UCase(Me.textbox1)
End Sub

 

[John Big Booty]

You can also achieve this by putting a ">" greater than sign in the format field of the control. This can be done at either table or form level. This method only effects how the text is displayed, not how it is stored.

 

[JoeAcess]

thanks guys