Table Design - Initial Capitals Formatting

[Debbie D.]

Hi all,

In table design view for a text field I am aware that by using the '>' or
'<' I can make the text appear either in Upper case or Lower case. However
is there a way to make the text appear as Initial Capitals as in:

10 Live Here Avenue

Thanks all for taking the time to look at this and any help, examples,
directions very welcome. Thanks

Deb (UK)

 

[fredg]

Hi all,

In table design view for a text field I am aware that by using the '>' or
'<' I can make the text appear either in Upper case or Lower case. However
is there a way to make the text appear as Initial Capitals as in:

10 Live Here Avenue

Thanks all for taking the time to look at this and any help, examples,
directions very welcome. Thanks

Deb (UK)

No! Not in Table Design nor in Table Datasheet View.
However, as I know that you will be using a form to enter your data
(you will be won't you?) you can code the form's [Address] control's
AfterUpdate event:

Me![Address] = StrConv([Address],3)

and it will change
10 live here avenue
into
10 Live Here Avenue

Unfortunately it will also change
10 McDonald street into 10 Mcdonald Street, and
33 van Beethoven into 33 Van Beethoven
both of which are incorrect capitalization's.

 

[Debbie D.]

fredg,

Many thanks for your answer and this is now working great in forms. Do not
like to impose but you did hint at the problem How would I make the form
convert Mcdonald to McDonald or it is just to hard work. Thanks again really
appreciate your answer, you are my hero right now!!!

Deb D (UK)

Hi all,

In table design view for a text field I am aware that by using the '>' or
'<' I can make the text appear either in Upper case or Lower case. However
is there a way to make the text appear as Initial Capitals as in:

10 Live Here Avenue

Thanks all for taking the time to look at this and any help, examples,
directions very welcome. Thanks

Deb (UK)

No! Not in Table Design nor in Table Datasheet View.
However, as I know that you will be using a form to enter your data
(you will be won't you?) you can code the form's [Address] control's
AfterUpdate event:

Me![Address] = StrConv([Address],3)

and it will change
10 live here avenue
into
10 Live Here Avenue

Unfortunately it will also change
10 McDonald street into 10 Mcdonald Street, and
33 van Beethoven into 33 Van Beethoven
both of which are incorrect capitalization's.

 

[Michael Gramelspacher]

(e-mail address removed)>, (e-mail address removed)
says...

fredg,

Many thanks for your answer and this is now working great in forms. Do not
like to impose but you did hint at the problem How would I make the form
convert Mcdonald to McDonald or it is just to hard work. Thanks again really
appreciate your answer, you are my hero right now!!!

Deb D (UK)

Here is a function by Michael Rochler that is -- in my opinion
-- excellent:
http://groups.google.com/group/microsoft.public.access.formscod
ing/browse_frm/thread/e6b100df1f3cd892/82ea9b8c701640e1?
lnk=st&q=Michael+Rochler+ProperCase&rnum=2&hl=en#
82ea9b8c701640e1

 

[Debbie D.]

Thanks Michael and fredg for answering my question. Both your help and
guidence has been great!!