Taking value from Rich Text box

[Ekhart]

I have a program that takes a bunch of data from a form and inputs it to a third party program. On this form there is a rich text box that compiles a list of comments and enters them in the comments field. They are displayed as:

Comment 1
Comment 2
Comment 3
Comment 4



and so on so forth (obviously with actual comments in). These comments are compiled via checkboxes the user selects and I have code that adds these in using </br> to keep adding the comments on new lines. This looks great in the text box but later when VBA grabs the data it shows the </br> again so instead of putting the value in like above it enters it like:
Comment 1 </br> Comment 2 </br> Comment 3 </br> Comment 4

If I manually hightlight and copy the text from the text box and paste it in the program it works fine. Basically, is there a way to get just the VALUE of a field using VBA?
I usually test these with msgbox's so the code I am testing with is:

MsgBox Forms!frmTestForm.Form!ConsultAddComment

I have also tried adding a .value to the end with no success, it keeps showing the </br>'s.

[June7]

Try Replace() function.

Replace([fieldname], "</br>", Chr(13) & Chr(10))

or

Replace([fieldname], "</br>", "; ")

Why use rich text? If this one code is the only reason you use rich text, consider, vbCrLf in concatenation instead of </br>.