How to get all fields to convert to Upper Case after being edited ?

  • Thread starter Thread starter Adam
  • Start date Start date
A

Adam

Hi all,

when a user adds or edits a record I would like it to convert everything to
uppercase - is there a simple way of achieving this via code ?

cheers,

Adam
 
Hi all,

when a user adds or edits a record I would like it to convert everything to
uppercase - is there a simple way of achieving this via code ?
Click to expand...

Well... ALL UPPERCASE IS UGLY AND HARD TO READ, and I really have to
question *why* you would want to do this except in very limited areas;
for instance, a two-letter State code in an address...

That said, you can put code in each text field's textbox's AfterUpdate
event:

Private Sub txtMyTextbox_AfterUpdate()
Me!txtMyTextbox = UCase(Me!txtMyTextbox)
End Sub

or, set the Form's KeyPreview property to True and use the KeyPress
event to detect each lower case letter and turn it to upper.
 
Back
Top