S
Simon Davies
Access 2K
Can anyone tell me how to format a textbox to "Title
Case" ?
Thanks in advance
Simon
Can anyone tell me how to format a textbox to "Title
Case" ?
Thanks in advance
Simon
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
L
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
S
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
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
.
M
Marshall Barton
Simon said: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.
A
AZF
Try the following...
=StrConv([YourField],3)instead of vbProperCase, and
remember to rename the object something other
than "YourField".
--AZF
=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
.