Upper Case

[TeeTime]

My current Database has a provision for assigning
automatic capitolization to specified fields. Does
Access have this feature and if so how & where.
Thank you.

 

[Ronald W. Roberts]

My current Database has a provision for assigning
automatic capitolization to specified fields. Does
Access have this feature and if so how & where.
Thank you.

In table design view look at validation rules. You may be able to use the
UCase function to do it.

 

[John Nurick]

Hi TeeTime,

One way is to use an input mask on the field. Start the mask with > to
force uppercase.

So for a field that must contain 5 uppercase letters you'd use

LLLLL

and a validation rule like
Is Null Or Like "[A-Z][A-Z][A-Z][A-Z][A-Z]"
while for a field that can contain up to 10 characters (but not
lowercase letters) the mask would be

CCCCCCCCCC

and the validation rule something like
Is Null Or Not Like "*[a-z]*"

More subtle effects can be achieved by using forms and VBA code.

 

[GVaught]

Or much simpler, type > in the Format section property of the field either
in the table and/or the form.