Changing Case

[Karl Krelove]

How do I change the contents of specific fields in all
records of an Access 2000 database from all caps (UPPER
CASE) to "Title" case (Upper Case)?

Thanks for any help.

 

[Dirk Goldgar]

How do I change the contents of specific fields in all
records of an Access 2000 database from all caps (UPPER
CASE) to "Title" case (Upper Case)?

Thanks for any help.

Run an update query that updates each of those specific fields to
StrConv([the field], 3). For example:

UPDATE MyTable
SET ThisField = StrConv(ThisField, 3),
ThatField = StrConv(ThatField, 3);

 

[Karl Krelove]

Thanks - worked like a charm. I can't find any listing in
the Help files explaining any of the "built in functions"
in the Expression Builder. Where are the functions defined?

Karl

-----Original Message-----

How do I change the contents of specific fields in all
records of an Access 2000 database from all caps (UPPER
CASE) to "Title" case (Upper Case)?

Thanks for any help.

Run an update query that updates each of those specific fields to
StrConv([the field], 3). For example:

UPDATE MyTable
SET ThisField = StrConv(ThisField, 3),
ThatField = StrConv(ThatField, 3);

--
Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)


.

 

[John Vinson]

How do I change the contents of specific fields in all
records of an Access 2000 database from all caps (UPPER
CASE) to "Title" case (Upper Case)?

Thanks for any help.

Run an Update query updating the field to

=StrConv([fieldname], 3)

 

[Dirk Goldgar]

Thanks - worked like a charm. I can't find any listing in
the Help files explaining any of the "built in functions"
in the Expression Builder. Where are the functions defined?

Unfortunately, you see different help topics when you search from the
Access application window from when you search from the VB Editor
window. StrConv is a VBA function, and only shows up when you go into
the help file from the VB Editor.

 

[VJ1222]

ALL Caps

How do I get all of the information that is on one table to be ALL in CAPS. Is there a quick way of doing it manually?