Capitalize first letters in field

  • Thread starter Thread starter beth peluso
  • Start date Start date
B

beth peluso

I have an older version of access I wrote macros to capitalize first letters
in a field. EX : 25 Lee Street The command would automatically make the
L and S upper case . I cannot find how to do this in the newer versions of
Access. My older command would capitalize all first letters after a space or
symb. EX Paul O'Toole . In this example the P, O, & T are allswitched
to upper case. Any help from anyone will save time with my kids. thanks
 
hi Beth,

there is a simple function built into Access called Strconv that you can
use to capitalize all first letters after a space:

StrConv([fieldname], vbProperCase)

what it will NOT do is anything special after a symbol.

is the old 'macro' that you said you have actually VBA code? If so,
post it and we will help you get it working again

"save time with my kids"

hey, I am all for that!

Warm Regards,
Crystal

Access Basics
8-part free tutorial that covers essentials in Access
http://www.accessmvp.com/Strive4Peace/Index.htm

*
(: have an awesome day :)
*
 
I tried your answer in a query and it didn't run. ("Type conversion
failure"). When I looked up strconv() help it said to put an integer code
(3) in the place of your "vbProperCase". Then it worked. but it referred
to your "vbProperCase" in the table. Could you explain this for this
programming newbie?

Thanks

Fred


strive4peace said:
hi Beth,

there is a simple function built into Access called Strconv that you can
use to capitalize all first letters after a space:

StrConv([fieldname], vbProperCase)

what it will NOT do is anything special after a symbol.

is the old 'macro' that you said you have actually VBA code? If so,
post it and we will help you get it working again

"save time with my kids"

hey, I am all for that!

Warm Regards,
Crystal

Access Basics
8-part free tutorial that covers essentials in Access
http://www.accessmvp.com/Strive4Peace/Index.htm

*
(: have an awesome day :)
*



beth said:
I have an older version of access I wrote macros to capitalize first letters
in a field. EX : 25 Lee Street The command would automatically make the
L and S upper case . I cannot find how to do this in the newer versions of
Access. My older command would capitalize all first letters after a space or
symb. EX Paul O'Toole . In this example the P, O, & T are allswitched
to upper case. Any help from anyone will save time with my kids. thanks
Click to expand...
Click to expand...
 
Hello Chrystal,

Thanks!

Fred

strive4peace said:
Hi Fred,

thanks for posting :)

vbProperCase is the name of a built-in constant for Access that
represents the number 3

the constant is always available in code ... forgot to mention that you
have to actually use the numeric value in queries

normally, I use code to correct an entry on the control AfterUpdate
event of a form <smile>

Warm Regards,
Crystal

Access Basics
8-part free tutorial that covers essentials in Access
http://www.accessmvp.com/Strive4Peace/Index.htm

*
(: have an awesome day :)
*


I tried your answer in a query and it didn't run. ("Type conversion
failure"). When I looked up strconv() help it said to put an integer code
(3) in the place of your "vbProperCase". Then it worked. but it referred
to your "vbProperCase" in the table. Could you explain this for this
programming newbie?

Thanks

Fred


strive4peace said:
hi Beth,

there is a simple function built into Access called Strconv that you can
use to capitalize all first letters after a space:

StrConv([fieldname], vbProperCase)

what it will NOT do is anything special after a symbol.

is the old 'macro' that you said you have actually VBA code? If so,
post it and we will help you get it working again

"save time with my kids"

hey, I am all for that!

Warm Regards,
Crystal

Access Basics
8-part free tutorial that covers essentials in Access
http://www.accessmvp.com/Strive4Peace/Index.htm

*
(: have an awesome day :)
*



beth peluso wrote:
I have an older version of access I wrote macros to capitalize first letters
in a field. EX : 25 Lee Street The command would automatically make the
L and S upper case . I cannot find how to do this in the newer versions of
Access. My older command would capitalize all first letters after a space or
symb. EX Paul O'Toole . In this example the P, O, & T are allswitched
to upper case. Any help from anyone will save time with my kids. thanks
Click to expand...
Click to expand...
Click to expand...
 
Hi Fred,

thanks for posting :)

vbProperCase is the name of a built-in constant for Access that
represents the number 3

the constant is always available in code ... forgot to mention that you
have to actually use the numeric value in queries

normally, I use code to correct an entry on the control AfterUpdate
event of a form <smile>

Warm Regards,
Crystal

Access Basics
8-part free tutorial that covers essentials in Access
http://www.accessmvp.com/Strive4Peace/Index.htm

*
(: have an awesome day :)
*


I tried your answer in a query and it didn't run. ("Type conversion
failure"). When I looked up strconv() help it said to put an integer code
(3) in the place of your "vbProperCase". Then it worked. but it referred
to your "vbProperCase" in the table. Could you explain this for this
programming newbie?

Thanks

Fred


strive4peace said:
hi Beth,

there is a simple function built into Access called Strconv that you can
use to capitalize all first letters after a space:

StrConv([fieldname], vbProperCase)

what it will NOT do is anything special after a symbol.

is the old 'macro' that you said you have actually VBA code? If so,
post it and we will help you get it working again

"save time with my kids"

hey, I am all for that!

Warm Regards,
Crystal

Access Basics
8-part free tutorial that covers essentials in Access
http://www.accessmvp.com/Strive4Peace/Index.htm

*
(: have an awesome day :)
*



beth said:
I have an older version of access I wrote macros to capitalize first letters
in a field. EX : 25 Lee Street The command would automatically make the
L and S upper case . I cannot find how to do this in the newer versions of
Access. My older command would capitalize all first letters after a space or
symb. EX Paul O'Toole . In this example the P, O, & T are allswitched
to upper case. Any help from anyone will save time with my kids. thanks
Click to expand...
Click to expand...
Click to expand...
 
you're welcome, Fred ;) happy to help

Warm Regards,
Crystal

Access Basics
8-part free tutorial that covers essentials in Access
http://www.accessmvp.com/Strive4Peace/Index.htm

*
(: have an awesome day :)
*


Hello Chrystal,

Thanks!

Fred

strive4peace said:
Hi Fred,

thanks for posting :)

vbProperCase is the name of a built-in constant for Access that
represents the number 3

the constant is always available in code ... forgot to mention that you
have to actually use the numeric value in queries

normally, I use code to correct an entry on the control AfterUpdate
event of a form <smile>

Warm Regards,
Crystal

Access Basics
8-part free tutorial that covers essentials in Access
http://www.accessmvp.com/Strive4Peace/Index.htm

*
(: have an awesome day :)
*


I tried your answer in a query and it didn't run. ("Type conversion
failure"). When I looked up strconv() help it said to put an integer code
(3) in the place of your "vbProperCase". Then it worked. but it referred
to your "vbProperCase" in the table. Could you explain this for this
programming newbie?

Thanks

Fred


:

hi Beth,

there is a simple function built into Access called Strconv that you can
use to capitalize all first letters after a space:

StrConv([fieldname], vbProperCase)

what it will NOT do is anything special after a symbol.

is the old 'macro' that you said you have actually VBA code? If so,
post it and we will help you get it working again

"save time with my kids"

hey, I am all for that!

Warm Regards,
Crystal

Access Basics
8-part free tutorial that covers essentials in Access
http://www.accessmvp.com/Strive4Peace/Index.htm

*
(: have an awesome day :)
*



beth peluso wrote:
I have an older version of access I wrote macros to capitalize first letters
in a field. EX : 25 Lee Street The command would automatically make the
L and S upper case . I cannot find how to do this in the newer versions of
Access. My older command would capitalize all first letters after a space or
symb. EX Paul O'Toole . In this example the P, O, & T are allswitched
to upper case. Any help from anyone will save time with my kids. thanks
Click to expand...
Click to expand...
Click to expand...
 
Back
Top