How to remove a new line from a field in Crystal Reports version 7 (horribly complicated! :^D):

if InStr({Student.Address}, chr(13) + chr(10)) > 0 then
   left( {Student.Address}, InStr({Student.Address}, chr(13) + chr(10)) - 1 )
   + right( {Student.Address}, length({Student.Address}) - InStr({Student.Address}, chr(13) + chr(10)) - 1 )
else
   {Student.Address}