Lower case for email field only

[yoshe]

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.

 

[TheAceMan1]

How are ya yoshe . . .

Just exclude that field in your code. Something like:

[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]

See Ya! . . . . . .

Be sure to see thread181-473997 [blue]Worthy Reading![/blue]
Also faq181-2886 [blue]Worthy Reading![/blue]

 

[yoshe]

Thank you AceMan1 - worked like a charm!