Capitalize names

[Anthony Viscomi]

One of my users entered names into our db with all CAPS; normally I wouldn't
mind but we use that field for mail merges. Is there a way I can
automatically convert this field to First Letter CAP & First Letter after
space CAP?

Also is there an input mask that I can put into place in order to
prevent this from happening again?

Thanks in advance!
Anthony

 

[Jeff Boyce]

Anthony

In your query (you ARE using a query, right?), use the StrConv() function to
convert to "proper case". It will look something like:
ReformatedName: StrConv([YourNameField],3)

Now the bad news!

Your post implies that the name is entered into a single field, rather than
LastName and FirstName and MiddleName fields. Consider creating separate
fields for the separate names.

Also, the StrConv() function may return some "unusual" conversions. For
example, if your names include:

CLAUDE VAN DAMME
ROBERT O'BRIEN
RONALD MCDONALD,

StrConv() will NOT give you:

Claude van Damme
Robert O'Brien
Ronald McDonald

Instead, you'll get:

Claude Van Damme
Robert O'brien
Ronald Mcdonald

You can use an input mask that forces lower case, or you can add code that
converts everything entered into lower case. And you will still have the
problem mentioned above!

Good luck!

--
Regards

Jeff Boyce
Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

Microsoft Registered Partner
https://partner.microsoft.com/