?
Solved

Access 2013 - Query Question - String Formatting

Posted on 2016-08-09
4
Medium Priority
?
45 Views
Last Modified: 2016-08-09
Greetings!
I have this in one of my queries, and I need to have it return the value in Proper Case.

FirstNameBase: IIf(InStr([Record Disposition]![Customer],Chr$(32))>0,Mid([Record Disposition]![Customer],1,InStr([Record Disposition]![Customer],Chr$(32))-1),[Record Disposition]![Customer])

Thanks!
Dennis
0
Comment
Question by:DGWhittaker
  • 3
4 Comments
 
LVL 11

Accepted Solution

by:
Craig Yellick earned 2000 total points
ID: 41749500
Use the StrConv function with option 3 which makes each first letter upper case.

StrConv("test me",3)

Open in new window


-- Craig
0
 

Author Comment

by:DGWhittaker
ID: 41749505
Thanks Craig!

Okay, I tried that, but with this approach it gives me an invalid syntax error:

FirstName:StrConv(FirstNameBase: IIf(InStr([Record Disposition]![Customer],Chr$(32))>0,Mid([Record Disposition]![Customer],1,InStr([Record Disposition]![Customer],Chr$(32))-1),[Record Disposition]![Customer]),3)

Thougths!
Thanks!
Dennis
0
 

Author Comment

by:DGWhittaker
ID: 41749508
Oops, nevermind, I  had some noise in there where I copied from my original formula.
All is good in the lands!
Thanks Craig!
Dennis
0
 

Author Closing Comment

by:DGWhittaker
ID: 41749509
Perfect!
Thanks!
Dennis
0

Featured Post

Upgrade your Question Security!

Add Premium security features to your question to ensure its privacy or anonymity. Learn more about your ability to control Question Security today.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Explore the ways to Unlock VBA Project Password Excel 2010 & 2013 documents. Go through the article and perform the steps carefully to remove VBA Excel .xls file.
Sometimes MS breaks things just for fun... In Access 2003, only the maximum allowable SQL string length could cause problems as you built a recordset. Now, when using string data in a WHERE clause, the 'identifier' maximum is 128 characters. So, …
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…
Suggested Courses

807 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question