Case Conversion

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How can I convert a field which contains upper case letters to normal case.
For example from: "WATFORD HIGH STREET" to: "Watford High Street". In Excel
there is a simple conversion function called Proper that will convert from
UPPER CASE to Proper Names.
 
Pedro said:
How can I convert a field which contains upper case letters to normal
case. For example from: "WATFORD HIGH STREET" to: "Watford High
Street". In Excel there is a simple conversion function called
Proper that will convert from UPPER CASE to Proper Names.
Click to expand...

Update query...

UPDATE TableName
SET [TableName]![FieldName] = StrConv([TableName]![FieldName], 3)
 
Pedro

Rick's response will convert your field contents to "Proper Case". Please
note that this is not 100% the way you'd want it. For example:

Old Mcdonald (not McDonald)
Tony De Silva (not de Silva)
O'brien (not O'Brien)

For these, you'll either have to use a more complicated conversion, with
exceptions, or you'll need a USB approach (use someone's brain!) to clean up
after the initial conversion.

Good luck

Jeff Boyce
<Access MVP>
 
Back
Top