Making all entries to a table upper case

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Alylia - 16 Mar 2006 12:49 GMT

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.

Reply to this Message

Duane Hookom - 16 Mar 2006 13:16 GMT

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

Signature

Duane Hookom
MS Access MVP
--

> Hello,
>
[quoted text clipped - 4 lines]
>
> Alvin.

Reply to this Message