Access 2007 Unbound Text Field Question

Hi everyone,

I have an Unbound Text Box field called Case Number.  The Case Number has maximum characters of 12.  Most  all of the number will be numeric characters, but I will have some alpha characters always on the end such as DL, DS, A, O, and X.  I need for these characters to be UPPER CASE and not LOWER CASE automatically when the user tries to enter them and not Lower Case.   Do you know of a setting that I can do that will make this field automatically take UPPER CASE Letters on the Alpha Characters entered in?

jjc9809
jjc9809Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Dale FyeCommented:
You can set the KeyPreview property of the form to Yes, then use the textboxes KeyPress event as follows:

Private Sub txt_CaseNumber_KeyPress(KeyAscii as Integer)

    KeyAscii = Asc(UCase(Chr$(KeyAscii)))
   
End Sub
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
jjc9809Author Commented:
works good.

thanks
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.