Query to convert to Proper Case

  • Thread starter Thread starter Bikini Browser
  • Start date Start date
B

Bikini Browser

Hey everyone!! Happy Valentines Day!

Does anyone have a query that will let me convert a field in a table to
Proper Case? I need every word in the field converted.

Can any one help me?

Thanks in advance...

Dale
 
Are you saying you want the values in the field converted, or a query that
returns the values converted. The former is an update query, the latter a
select query.

You can use something like:

Expr1: StrConv([YourFieldName],3)

in a field in the query to display the contents of [YourFieldName] in Proper
Case (first letter of each word capitalized).

Just remember, Access is stupid, and will do exactly what you tell it to.
All of the following:

WILLIAM O'BRIEN
MacDonalds
samuel de clerke
jean-claude van damme
ab cde fghij

will be converted to:

William O'brien
Macdonalds
Samuel De Clerke
Jean-claude Van Damme
Ab Cde Fghij
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Convert to Proper or Title Case in Access 2003 2
Changing UPPER to Proper Case 1
UPPER CASE to Proper Case 2
What software do you use to convert between audio files? 6
Convert WAV to MP3 4
query on date 1
how to convert uppercase to proper name using update query 4
Tweaking a query 1

Back
Top