Solved

Input Mask for Proper Case

Posted on 2003-10-21
5
409 Views
Last Modified: 2010-08-05
Hello,

I have the proper function that will change all my existing data to proper case from uppercase, but I would like to know how do I force the user to type the data in as Proper case to begin with?

Any suggestions?
Thanks
0
Comment
Question by:Jennerator
  • 3
5 Comments
 
LVL 77

Expert Comment

by:peter57r
ID: 9595349
What would be the point?

Pete
0
 

Accepted Solution

by:
Icart earned 50 total points
ID: 9595373
You cannot force a Propercase" like Lowercase or Uppercase.

On the AfterUpdate event of the field put

MyField = Proper(MyField)
0
 
LVL 77

Expert Comment

by:peter57r
ID: 9595405
'MyField = Proper(MyField)'

Don't think so!  You must have a user defined function in your database.

strconv(myfield, vbProperCase)

Pete
0
 
LVL 77

Expert Comment

by:peter57r
ID: 9595406
'MyField = Proper(MyField)'

Don't think so!  You must have a user defined function in your database.

strconv(myfield, vbProperCase)

Pete
0
 

Author Comment

by:Jennerator
ID: 9596147
Thank you for your help, I got it to work.
0

Featured Post

Complete Microsoft Windows PC® & Mac Backup

Backup and recovery solutions to protect all your PCs & Mac– on-premises or in remote locations. Acronis backs up entire PC or Mac with patented reliable disk imaging technology and you will be able to restore workstations to a new, dissimilar hardware in minutes.

Join & Write a Comment

In Debugging – Part 1, you learned the basics of the debugging process. You learned how to avoid bugs, as well as how to utilize the Immediate window in the debugging process. This article takes things to the next level by showing you how you can us…
Describes a method of obtaining an object variable to an already running instance of Microsoft Access so that it can be controlled via automation.
Familiarize people with the process of utilizing SQL Server views from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Access…
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…

705 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

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now