How to add a newline into a Query Field

[steenlf]

I am trying to add a newline into a Query Field statement.

Currently, my Query Field looks like this:

FullAddress: IIf(IsNull([Area]);[Address] & ", " & [ZIPCode] & " " & [City];[Address] & ", " & [Area] & ", " & [ZipCode] & " " & [City])

producing something like this:

Goofystreet 123, Townsville, 1234 Bigtown
or if Area is empty
Goofystreet 123, 1234 Bigtown

That works fine, but I would however like to see this:
Goofystreet 123
Townsville
1234 Bigtown
or if Area is emtpy
Goofystreet 123
1234 Bigtown

But how do I do that?
I have tried to substitute the ", " with chr(13) and chr$(13) and chr(10) and chr$(10) and vbCr and vbLf and vbCrLf, but it will not do the trick.

Does anybody know how to do that?

Thanx...