Upper and Lower Case formats

[Guest]

I'm aware of format UCase to convert all text to UPPER Case. I assume there
must be similar to create all lower case. I have a large table of imported
data where the LastNames are all in UPPER case. My objective, to convert all
the last names in the table to conventional format with just first letter in
upper case. An issue I'm already aware of is dealing with the "Van Winlkles"
and the "Robertson-Davies".

I'm thinking an update-query is a good approach, but looking for a little
further guidance. Any suggestions?......thanks

 

[Sergey Poberezovskiy]

You can try using
StrConv(inputString, vbProperCase)

HTH

 

[Tom Wickerath]

An update query is exactly what you need. Create an update query as follows, using the built-in
StrConv function:

Field: YourFieldName
Table: YourTableName
Update To: StrConv([YourFieldName],3)


Or, the equivalent SQL view would be:

UPDATE [YourTableName]
SET [YourTableName].[YourFieldName] = StrConv([YourFieldName],3);


If your name data is all in one field, an alternative to consider is using a utility called
Splitter for Microsoft Access. This utility can automatically correct the case at the same time
that it splits name data.

http://www.infoplan.com.au/splitter/


Tom
_______________________________


I'm aware of format UCase to convert all text to UPPER Case. I assume there
must be similar to create all lower case. I have a large table of imported
data where the LastNames are all in UPPER case. My objective, to convert all
the last names in the table to conventional format with just first letter in
upper case. An issue I'm already aware of is dealing with the "Van Winlkles"
and the "Robertson-Davies".

I'm thinking an update-query is a good approach, but looking for a little
further guidance. Any suggestions?......thanks