can i capatilize words saved in access?

[Anthony]

I have a database that I'm updating and making mailing labels for, and so i
don't have to retype all the information, I was trying to find out if there
is any way to capatalize the data that is already there, the information is
proper names of titles, schools, streets, city, and states because by policy
all labels have to have capatilized information on them.

 

[KARL DEWEY]

Try an update query with this --
strconv([YourField], 3)

1 = ALL CAPS
2 = all lower case
3 = Initial Caps For Each Word

 

[David Lloyd]

Anthony:

One alternative is to create a query and use the UCase function to
capitalize the necessary fields. For example:

SELECT UCase([Title]) as UTitle, UCase([School]) as USchool,
UCase([StreetAddress]) as UStreetAddress, UCase([City]) as UCity, ...
FROM MyTable

You can then use the query to make the labels, rather than the underlying
table. This will leave the table data in its current proper case format.


--
David Lloyd
MCSD .NET
http://LemingtonConsulting.com

This response is supplied "as is" without any representations or warranties.


I have a database that I'm updating and making mailing labels for, and so i
don't have to retype all the information, I was trying to find out if there
is any way to capatalize the data that is already there, the information is
proper names of titles, schools, streets, city, and states because by policy
all labels have to have capatilized information on them.

 

[Anthony]

karl

How would i do an update query, and is the formula you are giving me:
--strconv([Your Field], 3 now in the your field am i putting the title of the
field?

Try an update query with this --
strconv([YourField], 3)

1 = ALL CAPS
2 = all lower case
3 = Initial Caps For Each Word

I have a database that I'm updating and making mailing labels for, and so i
don't have to retype all the information, I was trying to find out if there
is any way to capatalize the data that is already there, the information is
proper names of titles, schools, streets, city, and states because by policy
all labels have to have capatilized information on them.

 

[Graham Mandeno]

Anthony,

Don't change the data in your table. The moment you do that, someone is
going to want the output in mixed case, and it is *much* harder to change it
back.

I suggest you store the data in mixed case and, as David has shown, use the
UCase function in a query whenever some old-fashioned person wants to be
shouted at
--
Good Luck!

Graham Mandeno [Access MVP]
Auckland, New Zealand

karl

How would i do an update query, and is the formula you are giving me:
--strconv([Your Field], 3 now in the your field am i putting the title of
the
field?

Try an update query with this --
strconv([YourField], 3)

1 = ALL CAPS
2 = all lower case
3 = Initial Caps For Each Word

I have a database that I'm updating and making mailing labels for, and
so i
don't have to retype all the information, I was trying to find out if
there
is any way to capatalize the data that is already there, the
information is
proper names of titles, schools, streets, city, and states because by
policy
all labels have to have capatilized information on them.

 

[KARL DEWEY]

How would i do an update query ----
The same as any other query. Open the query in design view and on the icon
bar the icon that looks like a copy icon but the copies are upper right and
lower left instead of upper left and lower right. It also has a down arrow
as it is a pull down window. Select Update Query.

is the formula you are giving me: strconv([Your Field],3) now in the your field am i putting the title of the field?

[Your Field] will be the data field you want to change.

Put the 'formula' in the column of your data field in the UPDATE TO row of
the design grid.

WARNING --- Always make a backup copy of your table before you do something
like this - especially if you are not familiar with the process!!!!!

karl

How would i do an update query, and is the formula you are giving me:
--strconv([Your Field], 3 now in the your field am i putting the title of the
field?

Try an update query with this --
strconv([YourField], 3)

1 = ALL CAPS
2 = all lower case
3 = Initial Caps For Each Word

I have a database that I'm updating and making mailing labels for, and so i
don't have to retype all the information, I was trying to find out if there
is any way to capatalize the data that is already there, the information is
proper names of titles, schools, streets, city, and states because by policy
all labels have to have capatilized information on them.