Caps Lock

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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
 
Thanks

Jon Lewis said:
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
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Combo Box with Caps Locki 2
Table set up 5
Field formatting 3
Caps Lock problem 14
Suddenly Cap Lock ON even when keyboard light off 1
Initial Caps Problem 6
CAPS LOCK KEY 1
Text Format in Tables... 2

Back
Top