Making all entries to a table upper case

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

 

[Duane Hookom]

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.... :-(