Title Case

[Simon Davies]

Access 2K

Can anyone tell me how to format a textbox to "Title
Case" ?

Thanks in advance

Simon

 

[Larry Linson]

Can anyone tell me how to format
a textbox to "Title Case" ?

Set its Control Source to "= StrConv([yourfield], vbProperCase)" without the
quotes, where you replace "yourfield" with the name of the field which you
want displayed in Proper Case. I believe what you describe as Title Case is
the same as Proper Case... each word capitalized.

Larry Linson
Microsoft Access MVP

 

[Simon Davies]

Thanks for your help but I am experiencing problems- when
I type in the source code as suggested the "vbProperCase"
automatically brackets itself. ie [vbProperCase].
When opening the report I am then asked for input to
vbProperCase.
Any suggestions

Simon

-----Original Message-----

Can anyone tell me how to format
a textbox to "Title Case" ?

Set its Control Source to "= StrConv([yourfield], vbProperCase)" without the
quotes, where you replace "yourfield" with the name of the field which you
want displayed in Proper Case. I believe what you describe as Title Case is
the same as Proper Case... each word capitalized.

Larry Linson
Microsoft Access MVP


.

 

[Marshall Barton]

Thanks for your help but I am experiencing problems- when
I type in the source code as suggested the "vbProperCase"
automatically brackets itself. ie [vbProperCase].
When opening the report I am then asked for input to
vbProperCase.

If you have that in a text box's Control Source expression,
use the value (3) of the predefined constant instead of its
name.

 

[AZF]

Try the following...

=StrConv([YourField],3)instead of vbProperCase, and
remember to rename the object something other
than "YourField".

--AZF

-----Original Message-----
Thanks for your help but I am experiencing problems- when
I type in the source code as suggested the "vbProperCase"
automatically brackets itself. ie [vbProperCase].
When opening the report I am then asked for input to
vbProperCase.
Any suggestions

Simon

-----Original Message-----

Can anyone tell me how to format
a textbox to "Title Case" ?

Set its Control Source to "= StrConv([yourfield], vbProperCase)" without the
quotes, where you replace "yourfield" with the name of the field which you
want displayed in Proper Case. I believe what you describe as Title Case is
the same as Proper Case... each word capitalized.

Larry Linson
Microsoft Access MVP


.

.