Change from all UPPER case letters

[JohnL]

I have a field call LNAM and it lists last names. How can I "adjust" the
field so that only the first letter is upper case and the rest of the letters
are lower case?
Can it be done within the table via an input mask? Or in a query with some
type of Format function?

TIA

John

 

[Tom van Stiphout]

On Fri, 1 Aug 2008 19:57:00 -0700, JohnL

Use the StrConv function with vbProperCase.

-Tom.
Microsoft Access MVP

 

[Duane Hookom]

vbProperCase will work in a module but not a query. You will need to use
StrConv([Your field to change],3).

 

[Asad Ali]

Hi to all Group Member

yesterday I was searching from google som vedios
I hve just found a lagrest and greatest group of
online vedios on internet

which Is on daily bases
it updates vedios on daily bases
so must check it to keep intouch with the world to examine what is happing
in side our world

the link is
http://obm.itnews.googlepages.com

regards and thnanks

Asad ali
manager :E-Idea google Group
cell:+923217507176
Email:[email protected]
web:http://obm.itnews.googlepages.com

 

[Will I Am]

Hi,
It doesn't work for names with an apostrophe i.e. o'donnell.
Any ideas around this?

vbProperCase will work in a module but not a query. You will need to use
StrConv([Your field to change],3).
--
Duane Hookom
Microsoft Access MVP

On Fri, 1 Aug 2008 19:57:00 -0700, JohnL

Use the StrConv function with vbProperCase.

-Tom.
Microsoft Access MVP

 

[Duane Hookom]

Either create your own function or search the web for a good one.

--
Duane Hookom
Microsoft Access MVP

Hi,
It doesn't work for names with an apostrophe i.e. o'donnell.
Any ideas around this?

vbProperCase will work in a module but not a query. You will need to use
StrConv([Your field to change],3).
--
Duane Hookom
Microsoft Access MVP

On Fri, 1 Aug 2008 19:57:00 -0700, JohnL

Use the StrConv function with vbProperCase.

-Tom.
Microsoft Access MVP


I have a field call LNAM and it lists last names. How can I "adjust" the
field so that only the first letter is upper case and the rest of the letters
are lower case?
Can it be done within the table via an input mask? Or in a query with some
type of Format function?

TIA

John