Capital Letters

[Presto731]

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?

[missinglinq]

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

>

Linq ;0)>

[Presto731]

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!

[Stewart Ross]

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!

[missinglinq]

How much simpler do you want it than entering one character?

[Presto731]

How much simpler do you want it than entering one character?

i was only kidding, it was very simple.