Data Entry Format

[jlgray0127]

I need to have all my data entered in all fields, on all forms, in CAPS.
I found the below code, but can't seem to get it to work in Access 2000



Any thoughts?

Private Sub Form_KeyPress(KeyAscii As Integer)

KeyAscii = Asc(UCase(Chr(KeyAscii)))

End Sub

[RuralGuy]

Do you have KeyPreview set to Yes?

[RuralGuy]

Out of curiosity, why do you need all of the data in UpperCase? You can always display it that way regardless of the way it is entered and unless you make some changes, Access is *not* case sensitive.

[jlgray0127]

The SQL Server I am connected to will not accept lower case, so when I am trying to tie my data to the SQL Data for reporting, it does not find the values I am seeking.

[RuralGuy]

Thanks. What is your answer to my question in Post #2?

[jlgray0127]

Oh... No I don't... I added this code to the KeyPress event

Private Sub [YourControlName]_KeyPress(KeyAscii As Integer)
KeyAscii = Asc(UCase(Chr(KeyAscii)))
End Sub

[jlgray0127]

If I enter the code in Post one, and change the Property to yes, will this fix the issue I was having with trying to declare the event against the form?

[RuralGuy]

You will not get a KeyPress event until you set KeyPreview to yes.