Using Trim with StrConv Function

[rinova]

Hi Access Experts,

I'm having a problem using Trim with StrConv functions, when I use this code Trim works.

 FullName: Trim([dbo_sponsor]![spn_chair_person])

but when I add StrConv, Trim stops working. Below is the code that doesn't work.

 FullName: Trim(StrConv("Dear " & [dbo_sponsor]![spn_chair_person],3) & ":")

Any suggestions / answers?

Going to try to Trim first then then concatenate.

Thanks,

Rich

 

[pbaldy]

Try

FullName: Trim(StrConv("Dear " & [dbo_sponsor]![spn_chair_person],3)) & ":"

or

FullName: StrConv("Dear " & Trim([dbo_sponsor]![spn_chair_person]),3) & ":"

 

[rinova]

They both work perfectly. Thank you so much!

This will fix another problem I have in a different query.

THANK YOU SOOOOOO MUCH PBALDY!!!!

 

[pbaldy]

Happy to help!