[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 497
  • Last Modified:

Input Mask for Proper Case

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
Jennerator
Asked:
Jennerator
  • 3
1 Solution
 
peter57rCommented:
What would be the point?

Pete
0
 
IcartCommented:
You cannot force a Propercase" like Lowercase or Uppercase.

On the AfterUpdate event of the field put

MyField = Proper(MyField)
0
 
peter57rCommented:
'MyField = Proper(MyField)'

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

strconv(myfield, vbProperCase)

Pete
0
 
peter57rCommented:
'MyField = Proper(MyField)'

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

strconv(myfield, vbProperCase)

Pete
0
 
JenneratorAuthor Commented:
Thank you for your help, I got it to work.
0

Featured Post

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now