Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Lower case for email field only

Status
Not open for further replies.

yoshe

Technical User
Jan 12, 2007
36
US
Hello,
I am forcing upper case for all fields on my form using the form's key press event. For a field containing email address, I want to turn this off and allow whatever case. Does anyone have code for this? Thanks for your help.
 
How are ya yoshe . . .

Just exclude that field in your code. Something like:
Code:
[blue]   If Screen.ActiveControl.ControlType = acTextBox Then
      If Screen.ActiveControl.Name <> "[purple][B][I]EmailTextboxName[/I][/B][/purple]" Then
         [green]'Your uppercase code here[/green]
      End If
   End If[/blue]
[blue]Your Thoughts? . . .[/blue]

Calvin.gif
See Ya! . . . . . .

Be sure to see thread181-473997 [blue]Worthy Reading![/blue] [thumbsup2]
Also faq181-2886 [blue]Worthy Reading![/blue] [thumbsup2]
 
Thank you AceMan1 - worked like a charm! :)
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top