How Can I Set A Text Field To Only Allow Caps, Not Lower Case?

[Guest]

When a user enters data in a Access 2000 database text field, how can I set
the text field to only allow upper case letters?

 

[Smartin]

A 2nd option is to enter ">" in the format field in design view of the table.

:

But FYI to the OP, this will not prevent lower case characters from
populating the table, it will merely display everything in upper case.

 

[Guest]

Hello, I use Access 2003 and I want several fields entered in FrontPage form
to be all upper case. I did set the Style Font for the form field to "All
Caps". And in my Access 2003 database I used the ">" in the Format property
(using Design viewing mode for the Table and field). This > causes Access to
display the field as upper case but the actual DB field content remains lower
case. I have a DB full of lower case fields that I want to covert to upper
case for those fields. I do not understand exactly how I do this: Let the
user enter any text, and on the before update event of the field, change it
to upper case Me.FieldName = Ucase(Me.FieldName). Where do I find the
"update event" ? In Design view for the table? In a macro? Or can I do this
in a Access query?

This is what I need help with:
1) I must change the actual data in the tabel. I see the Ucase and Ucase$
but I dont understand how to use them and what the differences is for them.
If you can tell me how to set the field for an update query, I can run the
update query to set the fields.

2) Can I simpy set the Design field and have Access change all of the records?

I would really appreciate any help you can provide. Thank you.

 

[tina]

answered in your second post on the subject in this newsgroup, titled Re:
All CAPS in a table, posted 20 minutes after this post. please don't
multi-post. see http://home.att.net/~california.db/tips.html#aTip10 for more
information.