*Upshifting data entry

[JMorrell]

In a data entry form, I want the user to enter data in either CAPITAL or lower case letters. I want the table to be updated with only CAPITAL letters. Is this possible?

 

[Wayne Morgan]

There are a couple of ways to go about this. First, you can format the data
wherever you use it to be upper case, regardless of how it is stored.
Second, you can force it to upper case before storing it. To force the data
to upper case, adjust the case in the AfterUpdate event of the control on
the form.

Me.NameOfControl = UCase(Me.NameOfControl)

--
Wayne Morgan
Microsoft Access MVP

In a data entry form, I want the user to enter data in either CAPITAL or

lower case letters. I want the table to be updated with only CAPITAL
letters. Is this possible?

 

[JMorrell]

----- Wayne Morgan wrote: ----

There are a couple of ways to go about this. First, you can format the dat
wherever you use it to be upper case, regardless of how it is stored
Second, you can force it to upper case before storing it. To force the dat
to upper case, adjust the case in the AfterUpdate event of the control o
the form

Me.NameOfControl = UCase(Me.NameOfControl

--
Wayne Morga
Microsoft Access MV

In a data entry form, I want the user to enter data in either CAPITAL o

lower case letters. I want the table to be updated with only CAPITA
letters. Is this possible

This is fantastic! Thank you!