By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,574 Members | 3,021 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,574 IT Pros & Developers. It's quick & easy.

Capital Letters

Presto731
P: 53
HOW do i make the letters in various fields on a form always be capital no matter if they used capital letters or not when typing?
May 22 '08 #1
Share this Question
Share on Google+
5 Replies


missinglinq
Expert 2.5K+
P: 3,532
In Design View for the form, select the textbox, goto Properties - Format and in the Format Property type in the symbol

>

Linq ;0)>
May 22 '08 #2

Presto731
P: 53
In Design View for the form, select the textbox, goto Properties - Format and in the Format Property type in the symbol

>

Linq ;0)>
Do you have a simpler way :D

Thanks!
May 22 '08 #3

Expert Mod 2.5K+
P: 2,545
Hi Presto731. Linq has pointed you to the format property which allows you to force upper case, and you would be wise to follow his advice.

Formatting separates how values are presented from how they are stored. You do not need to convert text to upper case to display it that way.

If you need to refer to text in capitals for specific purposes you can always use a calculated field in a query with the Ucase function to do the conversion. This will not help you on your form (where you need to have bound fields, not calculated ones) and in any event it is not simpler.

For your forms, set the format property to uppercase using the very simple format code > as Linq said.

-Stewart


Do you have a simpler way :D

Thanks!
May 22 '08 #4

missinglinq
Expert 2.5K+
P: 3,532
How much simpler do you want it than entering one character?
May 22 '08 #5

Presto731
P: 53
How much simpler do you want it than entering one character?
i was only kidding, it was very simple.
Aug 26 '08 #6

Post your reply

Sign in to post your reply or Sign up for a free account.