Solved

Force upper case text in a form

Posted on 2004-09-10
3
398 Views
Last Modified: 2008-02-01
I have a simple login dialog box that has a text box (txtUser) and a Login button (cmdLogin).  The user will type their initials in the text box then clicking the login button verifies the initials and passes the txtUser to a global public variable (gstrUser).  I would like the gstrUser text to always be upper case so when they modify a record their initials are entered in the UserID field in the form.

How can I make gstrUser always be caps???

Thanks
0
Comment
Question by:beyondt
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
3 Comments
 
LVL 3

Accepted Solution

by:
BrentTemple earned 125 total points
ID: 12032573
When you pass the txtUser into the gstrUser, you could switch it to uppercase.   I'm assuming the command botton runs a little bit of vb.

gstrUser = UCASE(me.txtUser)

-Brent
0
 
LVL 4

Expert Comment

by:Excalibur_Software
ID: 12032969
another place you may want to add that code might be the before update event

Private Sub Form_BeforeUpdate(Cancel As Integer)

   gstrUser = Ucase(me.txtUser)

End Sub
0
 

Author Comment

by:beyondt
ID: 12034479
Thanks!!  There are many more questions to come.
0

Featured Post

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Access custom database properties are useful for storing miscellaneous bits of information in a format that persists through database closing and reopening.  This article shows how to create and use them.
Did you know that more than 4 billion data records have been recorded as lost or stolen since 2013? It was a staggering number brought to our attention during last week’s ManageEngine webinar, where attendees received a comprehensive look at the ma…
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

738 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question