input in column for State

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

Guest

How do I make input of 2 letters of state e.g. ca in the column for "state" so ca will show up automatically as uppercase CA? Anybody to help me out there? Please give explicite directions. Oper. system MS XP professional, Software MS Office professional suite 2003. Thank you for your promt response and for your help
Henry C. Cheng
(e-mail address removed)
 
Henry C. Cheng said:
How do I make input of 2 letters of state e.g. ca in the column for
"state" so ca will show up automatically as uppercase CA? Anybody to
help me out there? Please give explicite directions. Oper. system MS
XP professional, Software MS Office professional suite 2003. Thank
you for your promt response and for your help. Henry C. Cheng
(e-mail address removed)
Click to expand...

One possibility is to use a combo box for the State field, based on a
table of states in which all the state codes are capitalized. That
would ensure both that the state code is capitallized and that no
invalid state code can be entered.

If you don't want to do this kind of validation or use a combo box, then
you could use a text box with code in its AfterUpdate event to convert
the control's value to upper case; e.g.,

Private Sub txtState_AfterUpdate()
Me.txtState = UCase(Me.txtState)
End Sub

If you want to automatically convert each keystroke to upper case as it
is entered, this can be done as well. However, I don't believe in doing
this, personally, and won't bother to show how unless you ask.
 
Back
Top