Inserting a new line when concatenating items

[rafi2]

Hi,

I have a report which concatenates several items together in a text box. To do the concatenation, I have followed the instructions as described here. What I would like to do now is be able to introduce a new line in the middle of the concatenated items.

I have tried creating an item who's value is simply a hard return, but access seems to save this as if it was a blank (empty) cell. I then created an item who's value is a hard return followed by a character, and it did what I wanted by introducing a new line in the concatenated field, but this also results in the character showing up as well.

Does anyone have any ideas on how to get around this?

Thanks,

Rafi.

 

[Sergeant]

Try this:
Me!AllProducts & vbCrLf & Me![ProductName]

 

[rafi2]

Thanks! That vbCrLf worked very well.