Caps Lock

[Confused Slug]

It is possible to set Caps Lock on when opening a database?

I have formated the fields and table etc to show all caps but when you edit
the data in a field (where the data was initially entered in lower case) the
text reverts to lower case during the edit phase.

 

[Jon Lewis]

Try suing the UCase function to convert the input to upper case.

e.g.

Private Sub MyTextBox_AfterUpdate()
Me.MyTextBox = UCase(Me.MyTextBox)
End Sub

The data will then be stored in upper case. Formatting controls how data is
displayed rather than how it is stored.

HTH

 

[Confused Slug]

Thanks

Try suing the UCase function to convert the input to upper case.

e.g.

Private Sub MyTextBox_AfterUpdate()
Me.MyTextBox = UCase(Me.MyTextBox)
End Sub

The data will then be stored in upper case. Formatting controls how data is
displayed rather than how it is stored.

HTH