By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
454,098 Members | 1,120 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 454,098 IT Pros & Developers. It's quick & easy.

First sign in a field needs to be a CAPITAL letter

P: n/a
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?
Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
"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

Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.