Link to home
Start Free TrialLog in
Avatar of DGWhittaker
DGWhittaker

asked on

Access 2013 - Query Question - String Formatting

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
ASKER CERTIFIED SOLUTION
Avatar of Craig Yellick
Craig Yellick
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of DGWhittaker
DGWhittaker

ASKER

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
Oops, nevermind, I  had some noise in there where I copied from my original formula.
All is good in the lands!
Thanks Craig!
Dennis
Perfect!
Thanks!
Dennis