LEFT function

[shank]

The below query works as expected until I add the LEFT function to get the
left 16 characters. I keep getting the entire string.

Menu:
Left(StrConv(Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace([SongList]![Title],"The
","")," and ","")," The ",""),Chr(44) & " THE",""),"
",""),Chr(44),""),"(",""),")",""),Chr(39),""),"-",""),".",""),"!",""),1),16)

What am I doing wrong?

thanks

 

[Jeff Boyce]

Have you already tried removing one Replace() at a time (innermost first)
until it works, then building back?

--
Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

 

[BruceM]

What happens if you remove StrConv? If that corrects the problem, could you
format a text box for all caps, or do you need to combine the string with
another mixed case string?
BTW, it seems you are removing all spaces (line breaks in the newsreader
make this a little unclear). If so you may be able to simplify a bit by
removing Chr(44) once, removing "The" once (strConv will ignore the case
unless you specify otherwise), and removing all spaces. However, I don't
know the details of your text, so I couldn't say for sure.