Capitalize first letters in field

[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

 

[strive4peace]

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
*

 

[Fred]

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
*

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

 

[Fred]

Hello Chrystal,

Thanks!

Fred

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

 

[strive4peace]

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
*

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

 

[strive4peace]

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

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