Changing Case

  • Thread starter Thread starter Karl Krelove
  • Start date Start date
K

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.
 
Karl Krelove said:
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.
Click to expand...

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);
 
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.
Click to expand...

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)


.
Click to expand...
 
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.
Click to expand...

Run an Update query updating the field to

=StrConv([fieldname], 3)
 
Karl Krelove said:
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?
Click to expand...

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.
 
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?
 
Back
Top