Login or Sign Up
Logging in...
Remember me
Log in
Or
Sign Up
Forgot password or user name?
Log in with
Search in titles only
Search in Access only
Search
Advanced Search
Forums
Product Launch
Updates
Today's Posts
Member List
Calendar
Home
Forum
Topic
Access
converting the entered text into uppercase and lowercase
Collapse
X
Collapse
Posts
Latest Activity
Photos
Page
of
1
Filter
Time
All Time
Today
Last Week
Last Month
Show
All
Discussions only
Photos only
Videos only
Links only
Polls only
Events only
Filtered by:
Clear All
new posts
Previous
template
Next
Dorji Wangchuk
New Member
Join Date:
Jul 2015
Posts:
1
#1
converting the entered text into uppercase and lowercase
Jul 15 '15, 09:06 AM
How can i read the entered text or sentence in a text box and display it in a form of uppercase,lower case in a level
jimatqsi
Moderator
Top Contributor
Join Date:
Oct 2006
Posts:
1293
#2
Jul 15 '15, 11:43 AM
Dorji,
The function ucase(sometext) will change to all upper case. lcase does the same for lower case.
So
Code:
me.sometextbox=ucase(me.sometextbox)
will do the trick.
Jim
Comment
Post
Cancel
jforbes
Recognized Expert
Top Contributor
Join Date:
Aug 2014
Posts:
1107
#3
Jul 15 '15, 03:03 PM
As Jim has offered, UCase() and LCase() are probably the best way.
If you want to Uppercase the first letter of every word and Lowercase the rest of the word (
CamelCase
), you can use
StrConv()
:
Code:
Me.SomeTextBox=StrConv(Me.SomeTextBox, 3)
Comment
Post
Cancel
Previous
template
Next
Working...
Yes
No
OK
OK
Cancel
👍
👎
☕
Comment