Access version of =Proper

[Dan]

I have a linked table that I can not adjust. In order to make the adjustments
I need I am using a Make Table Query. There are several fields such as [Last
Name] where the text is a varity on Capatalized, Non-Capatalized and a mix
and match of the two. I tried:

Last Name: UCase(Left([LAST_NAME],1)) & LCase(Mid([Last_name],2,99))

This works fine, however if there is a "McDonald" I get "Mcdonald" as to be
ecpected form the LCase. I know excel has an =Proper(cell) which does this.
There are far to many records to export, correct, and import. Is there access
version? Cant seem to find a function that works as desired. Thanks in
advance, cheers

 

[fredg]

I have a linked table that I can not adjust. In order to make the adjustments
I need I am using a Make Table Query. There are several fields such as [Last
Name] where the text is a varity on Capatalized, Non-Capatalized and a mix
and match of the two. I tried:

Last Name: UCase(Left([LAST_NAME],1)) & LCase(Mid([Last_name],2,99))

This works fine, however if there is a "McDonald" I get "Mcdonald" as to be
ecpected form the LCase. I know excel has an =Proper(cell) which does this.
There are far to many records to export, correct, and import. Is there access
version? Cant seem to find a function that works as desired. Thanks in
advance, cheers

In Access the function name is StrConv().
LastName:StrConv([Last_Name],3)

However this will not properly capitalize some names.
McDonald becomes Mcdonald, O'Reilly becomes O'reilly, etc. and it will
improperly capitalize some names which should not be capitalized, van
den Steen becomes Van Den Steen, etc.
I get around this by using a table of name exceptions and having a
user defined function look up the table to see if that name is in the
list and give the user the option to change or not change the entered
name.
Remember also, that some people capitalize their name differently than
others, McDonald and Mcdonald are both correct, as are O'Connor and
O'connor.