Formatting

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

TURNIP - 12 Mar 2006 20:12 GMT

Would anybody know of a code I could use in the format section of a field
wihich will cause only the first letter of seperate words to be in uppercase.

e.g.
A name in the format of John Smith?

Reply to this Message

fredg - 12 Mar 2006 20:25 GMT

> Would anybody know of a code I could use in the format section of a field
> wihich will cause only the first letter of seperate words to be in uppercase.
>
> e.g.
> A name in the format of John Smith?

Using a form for data entry, code the control's AfterUpdate event:
[FieldName] =strConv([FieldName],3)

Note: This will not properly capitalize names that should have more
than one capital letter, i.e. McDonald, O'Brien, Smith-Jones, ABC
Vending Co. etc. nor properly spell words that should not be
capitalized, van den Steen, etc.

If the names are already in the database, use an unbound control to
display them:
=StrConv([FieldName],3)

Signature

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

Reply to this Message

TURNIP - 12 Mar 2006 22:32 GMT

hanks for this, can you explain this one a bit further I am getting to grips
with Access, does this invove creating a macro or writing code?

> > Would anybody know of a code I could use in the format section of a field
> > wihich will cause only the first letter of seperate words to be in uppercase.
[quoted text clipped - 13 lines]
> display them:
> =StrConv([FieldName],3)

Reply to this Message