How do I format a field so lower case letters appear in upper case

M

mazda_enthusiast

Please help with the subject request, thank you! I also would like help with
how you make a field a required field... yout help is greatly appreciated.
 
E

elbyc

Please help with the subject request, thank you! I also would like help with
how you make a field a required field... yout help is greatly appreciated..
Click to expand...

For the subject request, in a query, use the function UCASE([your
field name]). So in the first line of the field column (design view)
you would type NameofNewField: Ucase([your field name]).

To make a field required, close the query, open the table in design
mode, click on the field you want to make required and set the
Required property to yes (field properties display at the bottom).
 
A

Arvin Meyer [MVP]

mazda_enthusiast said:
Please help with the subject request, thank you! I also would like help
with
how you make a field a required field... yout help is greatly appreciated.
Click to expand...

For merely formatting, use the Greater Than sign (>) in the format property
of your table. Actually storing data in uppercase requires an InputMask or a
function in the AfterUpdate event of a form.
 
Top