If the comment field is defined as a memo type you will get results like that - it doesn't matter how much text is in the comment.
try using left(comments,255).
Thanks. I checked the linked table and it is of type Long Text. It is strange that all select queries show it properly, but crosstab does not. Thanks for the help. left 254 fixed it.