Capitalize first letter of each word

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Donna - 12 Dec 2006 11:47 GMT

I need the "job location" field to display on a report with the first letter
of each word capitalized. (Preferably not the entire word) I know there is
a way to do it, just cannot find it in help. The users that are doing the
data entry are not going to be that careful.

Reply to this Message

Marshall Barton - 12 Dec 2006 16:57 GMT

>I need the "job location" field to display on a report with the first letter
>of each word capitalized. (Preferably not the entire word) I know there is
>a way to do it, just cannot find it in help. The users that are doing the
>data entry are not going to be that careful.

Check VBA Help for the StrConv function.

Signature

Marsh
MVP [MS Access]

Reply to this Message

fredg - 12 Dec 2006 17:09 GMT

> I need the "job location" field to display on a report with the first letter
> of each word capitalized. (Preferably not the entire word) I know there is
> a way to do it, just cannot find it in help. The users that are doing the
> data entry are not going to be that careful.

If you just wish to do this in the report (not saved to a table), add
an unbound text control to the report.
Set it's control source to:

= StrConv([JobLocation],3)

Be aware that this will not correctly capitalize some words, i.e.
Coeur d'Alene becomes Coeur D'alene, and King of Prussia becomes King
Of Prussia, while N.Y.C. becomes N.y.c.

Signature

Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail

Reply to this Message