Entries

[Pharah]

Hello all:

Just want to know: how can I restrict all entries (in the database) to ALL
CAPS?

Thank you in advance.

 

[Guest]

In table design set the Format property to upper case by typing in a greater
than sign ( > ).

 

[Pharah]

THANK YOU!

 

[Dirk Goldgar]

In table design set the Format property to upper case by typing in a
greater than sign ( > ).

Note, though, that this won't actually force the entries to upper
case -- it will only force them to be *displayed* in upper case. You
can use the ">" character at the start of an Input Mask to force the
letters typed to upper case, but then you have to specify the rest of
the input mask. The only solution I know of that doesn't involve an
input mask requires a little bit of VBA coding.