Text Format

[Mellissa via AccessMonster.com]

Hello,

I am using Access 2003.

I know that in Table Design view, I can set the Text Format for "all upper
case" by using the > symbol and "all lower case" by using the < symbol.

What if I want to set the Format to "all Proper Case" ?? What would be the
symbol to use in this case?

Thank you,
Mellissa

 

[Douglas J. Steele]

Unfortunately, there's no such symbol.

You shouldn't be working directly with tables anyhow. When you use a form,
you can put logic in the text box's BeforeUpdate event to use the StrConv
function (with a Conversion parameter of vbProperCase)

 

[Mellissa via AccessMonster.com]

Hi,

Thank you. I have enterred a code in the code builder beside BeforeUpdate.

However, I keep getting a Syntex Error message.

This is what I have enterred:

StrConv(ClientName,Conversion As VbProperCase)

I am provided with an example as I am typing which is...StrConv(String,
Conversion As VbStrConv, [LocalID As Long]

What am I missing in my equation?

I am trying to ensure the field ClientName is always Proper Case?

Thank you again
Mellissa

Unfortunately, there's no such symbol.

You shouldn't be working directly with tables anyhow. When you use a form,
you can put logic in the text box's BeforeUpdate event to use the StrConv
function (with a Conversion parameter of vbProperCase)

Hello,

[quoted text clipped - 8 lines]

Thank you,
Mellissa

 

[fredg]

Hello,

I am using Access 2003.

I know that in Table Design view, I can set the Text Format for "all upper
case" by using the > symbol and "all lower case" by using the < symbol.

What if I want to set the Format to "all Proper Case" ?? What would be the
symbol to use in this case?

Thank you,
Mellissa

1) You should NOT be entering data directly into a table.

2) Use a form for data entry.

3) Code the control's AfterUpdate event:
Me.[ControlName] = StrConv(Me.[ControlName],3)

4) Note: Proper Case will NOT properly capitalize many names that
require more than one capital letter, i,e, McDonald, Trent-Jones, O'
Connor, etc., and improperly capitalize names that should not be
capitalized, i.e. van der Meer, etc.

 

[Douglas J. Steele]

See Fred's response. (To me, it's arguable whether it's better to do it in
BeforeUpdate or AfterUpdate)

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

Hi,

Thank you. I have enterred a code in the code builder beside BeforeUpdate.

However, I keep getting a Syntex Error message.

This is what I have enterred:

StrConv(ClientName,Conversion As VbProperCase)

I am provided with an example as I am typing which is...StrConv(String,
Conversion As VbStrConv, [LocalID As Long]

What am I missing in my equation?

I am trying to ensure the field ClientName is always Proper Case?

Thank you again
Mellissa

Unfortunately, there's no such symbol.

You shouldn't be working directly with tables anyhow. When you use a form,
you can put logic in the text box's BeforeUpdate event to use the StrConv
function (with a Conversion parameter of vbProperCase)

Hello,

[quoted text clipped - 8 lines]

Thank you,
Mellissa