Text Format

  • Thread starter Thread starter Mellissa via AccessMonster.com
  • Start date Start date
M

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
 
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)
 
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,
Click to expand...
[quoted text clipped - 8 lines]
Thank you,
Mellissa
Click to expand...
Click to expand...
 
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
Click to expand...

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.
 
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!)


Mellissa via AccessMonster.com said:
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,
Click to expand...
[quoted text clipped - 8 lines]
Thank you,
Mellissa
Click to expand...
Click to expand...
Click to expand...
 
Back
Top