Recent content by Machnee

I'm always open to suggestions. Thx:D We use this in other places, and it does work nicely, including comboboxes and textboxes that are directly on forms. Just not comboboxes on datasheets for whatever reason.

Thanks for the idea. All the values in the combo are uppercase already, and limit to list is set in this case, so it will only save uppercase. We just want it to look better for the user when it converts to uppercase as they type.

We use an event like this to convert keystrokes to uppercase: Private Sub cboTest_KeyPress(KeyAscii As Integer) KeyAscii = Asc(UCase(Chr(KeyAscii))) End Sub It does not seem to work for ComboBoxes in Datasheet mode. The event fires, but keystrokes show up as lower case. Textboxes work...