Replacing <BR> in access reports

I have the guestbook app from webwiz which uses Access as the backend. The comments field is a memo field. In the ASP code used to input the data as a new record, it uses the REPLACE function so that when the user presses Enter in the <TEXTAREA>, the vbcrlf is replaced with a <BR>

However, the <BR> is stored in the field in the database - which s fine but now I want to generate an Access report - in Access. I don't want the <br> to print.

The report is based on a query. I've tried creating a new field in the query using the REPLACE function:

Expr1: Replace([Comments],"<br>",vbcrlf)

But it doesn't understand vbcrlf and if I put it in "" it actually puts the vbcrlf in the field

Any ideas?

Thanks

OK, that removes the <br>'s from the comments field, however, I do want it to print out on separate lines, for example, in the Comments field, I have

The cat sat <br>on the mat

When this is output to a browser using ASP, it prints

The cat sat
on the mat

I want it to print the same way in the access report. If I just remove the <br>'s it will print as

The cat sat on the mat

in the report. What I actually need to do is replace the <BR> which is stored in the memo field with a character that Access will not print at report runtime but which Access understands as a linebreak

Oh sorry, Try this then:

SELECT Replace(comments, '<br>', vbcrlf) As comments