Making all entries to a table upper case

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

Guest

Hello,

I would like assistance on what should be done to make all entries to a
table upper case if the person making the entries failed to turn on the cap
lock key to upper case.

Alvin.
 
You can use the After Update event of a control on a form like:

Me.txtYourTextBox = UCase(Me.txtYourTextBox)

For more immediate UCaseing, you could use the KeyPress event to upper case
the keystroke.

If you had a lot of these to program, you might try to make this more
generic.

I hate all caps.... :-(
 
Back
Top