Solved

Access 2013 - Query Question - String Formatting

Posted on 2016-08-09
4
36 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:
CraigYellick earned 500 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

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
update access form field from 5 other form fields 1 14
MS Access 2012, Split Form 2 38
Record with #Error 8 30
XML Node Counting in MS Access VBA 4 31
Introduction When developing Access applications, often we need to know whether an object exists.  This article presents a quick and reliable routine to determine if an object exists without that object being opened. If you wanted to inspect/ite…
It’s been over a month into 2017, and there is already a sophisticated Gmail phishing email making it rounds. New techniques and tactics, have given hackers a way to authentically impersonate your contacts.How it Works The attack works by targeti…
Familiarize people with the process of utilizing SQL Server views from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Access…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

789 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