*Upshifting data entry

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

Guest

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?
 
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


JMorrell said:
In a data entry form, I want the user to enter data in either CAPITAL or
Click to expand...
lower case letters. I want the table to be updated with only CAPITAL
letters. Is this possible?
 
----- 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


JMorrell said:
In a data entry form, I want the user to enter data in either CAPITAL o
Click to expand...
lower case letters. I want the table to be updated with only CAPITA
letters. Is this possible

This is fantastic! Thank you!
 
Back
Top