Inserting many many fields into one

M

Martin

Can anybody help?
What I want to do is put 3 or 4 fields from one table into
one field from another table. I have started do do this by
using a query and combining the fields as follows Address:
[Address1] & " " & [Address2]. Then using a code attached
a combo box I insert these values in the field on the
other table.
strAddress = DLookup("[Address]", "qryJobs", "[cboJobs]=
[PSNO]")txtAddress = strAddress

I works OK but I want to insert the values so that they
each appear on a new line in the field. ie

[Address1]
[Address2]

Thanks in advance

Martin
 
D

Douglas J. Steele

Address: [Address1] & Chr(13) & Chr(10) & [Address2].

If you were doing this in code, rather than a query, you could replace
Chr(13) & Chr(10) with vbCrLf
 
M

martin

Thanks that works a treat

-----Original Message-----
Address: [Address1] & Chr(13) & Chr(10) & [Address2].

If you were doing this in code, rather than a query, you could replace
Chr(13) & Chr(10) with vbCrLf

--
Doug Steele, Microsoft Access MVP

(No private e-mails, please)



Can anybody help?
What I want to do is put 3 or 4 fields from one table into
one field from another table. I have started do do this by
using a query and combining the fields as follows Address:
[Address1] & " " & [Address2]. Then using a code attached
a combo box I insert these values in the field on the
other table.
strAddress = DLookup("[Address]", "qryJobs", "[cboJobs]=
[PSNO]")txtAddress = strAddress

I works OK but I want to insert the values so that they
each appear on a new line in the field. ie

[Address1]
[Address2]

Thanks in advance

Martin
Click to expand...


.
Click to expand...
 
Top