View Single Post
  #1  
Old June 7th, 2010, 06:48 PM posted to microsoft.public.access.reports
PJ
external usenet poster
 
Posts: 265
Default First Letter of each word

I have the following in a text box field:

=IIf([Comp Entered By] Is Null,"",Left([Comp Entered By],1) & Mid([Comp
Entered By],InStr(1,[Comp Entered By],",")+2,1))

the field "Comp Entered By" is based off of a lookup table of names.

I want the above code to only give me the initials of any given name like:

Christian Many would be CM and the above code is giving me Ch.

What should I change on the above code?

Thanks in advance