combining 3 fields together

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello,

I would like to combine 2 field into 1 with a return between the two. I
tried the following data source but instead of a return so that the second
information begins on a new line I get a square symbol. Can someone
enlighten me so as to achieve what I need to do.

[DRM Comments] & Chr(10) & DLookUp("[DRM Drawing Status]","DRM Drawing
Status Tbl","[DRM Drawing Status Id] =" & [DRM Drawing Status])

Than you,

Daniel
 
Back
Top