Upper Case

[Sash]

Is there a way to make all the fields on a form upper case or do I nee to
touch each one and use UCase?

 

[Al Campagna]

Sash
You could set the Format of any text control to...No matter how the data is stored in the table, the "display" of that
text value will be in upper case.
Simply "multi-select" all your text controls, and enter > in the format.

Be aware however that all caps is more difficult to read than proper
case, and is usually avoided.
--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."

 

[Sash]

Al,
This is good to know, but I'm hoping to store the data as all caps. My
database is building a file to imported into a materials management system
that requires all caps.

 

[fredg]

Al,
This is good to know, but I'm hoping to store the data as all caps. My
database is building a file to imported into a materials management system
that requires all caps.

You can run an Update query to convert existing lower or mixed case
data into Upper case.

Update YourTable Set YourTable.[FieldName] = UCase([FieldName])

The above converts existing data.
To change data as it is entered into the form into Upper Case, code
that control's AfterUpdate event:
Me![ControlName] = UCase(Me![ControlName])

However the above AfterUpdate code will not effect data that is not
manually entered. If your data is imported, you'll have to import,
then immediately run the Update query.

 

[Chris]

In regards to Update Queries, is there a place to RUN this command?

Update YourTable Set YourTable.[FieldName] = UCase([FieldName])

or is there a procedure that may be followed in order to do so? I apologize
for posting to an older thread, but I couldn't find anything else that fit my
question.

Thank you.

Chris

Al,
This is good to know, but I'm hoping to store the data as all caps. My
database is building a file to imported into a materials management system
that requires all caps.

You can run an Update query to convert existing lower or mixed case
data into Upper case.

Update YourTable Set YourTable.[FieldName] = UCase([FieldName])

The above converts existing data.
To change data as it is entered into the form into Upper Case, code
that control's AfterUpdate event:
Me![ControlName] = UCase(Me![ControlName])

However the above AfterUpdate code will not effect data that is not
manually entered. If your data is imported, you'll have to import,
then immediately run the Update query.

 

[John W. Vinson]

In regards to Update Queries, is there a place to RUN this command?

Update YourTable Set YourTable.[FieldName] = UCase([FieldName])

You would create a new Query; open it in SQL view; and copy and paste this
into that window. Change YourTable to the name of your table, and FieldName to
the name of your field.

Alternatively, create a new query based on your table. Change it to an Update
query using the Query menu option, or the query type tool. A new row will
appear in the query design grid labeled "Update to". On that line, put

UCase([yourfieldnamehere])

underneath the field that you want to uppercase (using your actual fieldname
of course).

or is there a procedure that may be followed in order to do so? I apologize
for posting to an older thread, but I couldn't find anything else that fit my
question.

If you have a new question... just ask a new question. It's neither necessary
nor appropriate to tag your question onto somebody else's thread.