First sign in a field needs to be a CAPITAL letter

[Marc Verdonck]

First:
I have some troubles in access, some fields needs to begin with a Capital
letter.
Example: louiselaan need to be Louiselaan.
How can I become this?
Second:
I'm exporting my database to outlook. Than some names begin with a capital
letter some don't.
The name is always in capital letters in access and in outlook sometimes
it's capital sometimes not.
How can I correct this and make every Field just the same?

[Larry Linson]

"Marc Verdonck" wrote

First:
I have some troubles in access, some
fields needs to begin with a Capital
letter.
Example: louiselaan need to be Louiselaan.
How can I become this?
strCapitalized = StrConv(strAny, vbProperCase)

in code will capitalize the first letter of each word in strAny.

You can use the builtin StrConv function in code, in a Query, or in the
ControlSource of a CalculatedControl.
Second:
I'm exporting my database to outlook.
Than some names begin with a capital
letter some don't. The name is always in
capital letters in access and in outlook
sometimes it's capital sometimes not.
How can I correct this and make every
Field just the same?

See above. It seems likely that your data is being displayed properly in
Access because of the Format property of the Control in which it is shown,
but that it may be stored "as entered".

Larry Linson
Microsoft Access MVP