|
 |
access thread: forcing chars to upper case in text box
Message #1 by "Pardee, Roy E" <roy.e.pardee@l...> on Fri, 23 Feb 2001 10:51:47 -0800
|
|
Greetings all,
I know I can use an input mask like ">aaaaaaaaaaaaaaaaaaaaa" to force
characters entered into a text box to uppercase, but this has the
undesireable effect of forcing me to specify the # of characters that can be
entered into the box (which will no doubt change). I had hoped that just
specifying a mask of ">" with nothing else would give the desired behavior,
but no dice. Can anybody suggest an alternate method for getting this done?
Thanks!
-Roy
Roy Pardee
Lockheed-Martin SWFPAC Information Technology Group
(xxx) xxx-xxxx
Message #2 by "Bob Bedell" <bdbedell@m...> on Sat, 24 Feb 2001 00:00:23 -0500
|
|
Use the UCase() function in the control's AfterUpdate() event:
Private Sub txtTextBox_AfterUpdate()
Me!txtTextBox = UCase(Me!txtTextBox)
End Sub
Message #3 by "Bob Bedell" <bdbedell@m...> on Sat, 24 Feb 2001 08:07:52
|
|
> Greetings all,
>
> I know I can use an input mask like ">aaaaaaaaaaaaaaaaaaaaa" to force
> characters entered into a text box to uppercase, but this has the
> undesireable effect of forcing me to specify the # of characters that
can be
> entered into the box (which will no doubt change). I had hoped that just
> specifying a mask of ">" with nothing else would give the desired
behavior,
> but no dice. Can anybody suggest an alternate method for getting this
done?
>
> Thanks!
>
> -Roy
>
> Roy Pardee
> Lockheed-Martin SWFPAC Information Technology Group
> (xxx) xxx-xxxx
Message #4 by "Pardee, Roy E" <roy.e.pardee@l...> on Sun, 25 Feb 2001 09:49:51 -0800
|
|
Ach, of course!
Many thanks! (And thanks also to Clive Astley, who gave the same solution
offline.)
Cheers,
-Roy
-----Original Message-----
From: Bob Bedell [mailto:bdbedell@m...]
Sent: Friday, February 23, 2001 9:00 PM
To: Access
Subject: [access] RE: forcing chars to upper case in text box
Use the UCase() function in the control's AfterUpdate() event:
Private Sub txtTextBox_AfterUpdate()
Me!txtTextBox = UCase(Me!txtTextBox)
End Sub
|
|
|
View Cart
