Simple upper case question

  • Thread starter Thread starter RobertM
  • Start date Start date
R

RobertM

Hello:

I just need to know how to get any letters entered into
one of my fields to default to upper case.

For example, if a user enters 912795rn3 it needs to
convert to 912795RN3. I know this is Access 101 stuff, but
I must have slept through that part of the class.

Thank you
Robert
 
Dear Robert:

This is one of the options available through the Input Mask of
controls on a form. There is substantial online help for the topic
that gives you all the details.

Tom Ellison
Microsoft Access MVP
Ellison Enterprises - Your One Stop IT Experts
 
Hi Robert,

I slept through that part too - which is why the word "simple" always
attracts my attention ;o)

Here's a couple of ways:

Add a format mask to the field format property in table design view. The
mask character is ">" without the quotes.

or

In a form, add the same mask to the format property of the control that will
display the data.

or

Using VBA, place something like the following in the AfterUpdate event of
the control wchi displays the data:

Private Sub fldYourField_AfterUpdate()
Dim strYourString As String
strYourString = StrConv(Me.fldYourField, vbUpperCase)
Me.fldYourField = strYourString
End Sub
 
Back
Top