Concat with a return

  • Thread starter Thread starter Nigel Bennett
  • Start date Start date
N

Nigel Bennett

I would like to concat 2 fields together but I need to
enter a return between them so they will be on seperate
lines, is there any way of doing this

Thanks

Nigel
 
I would like to concat 2 fields together but I need to
enter a return between them so they will be on seperate
lines, is there any way of doing this

Thanks

Nigel
Click to expand...

field1 &vbcrlf &field2
 
MANFRED

No that doesn't work here is what I have

Expr1: [Address] &vbcrlf &[FIELD6]

and It thinks that vbcrlf is a field

any other ideas
-----Original Message-----


field1 &vbcrlf &field2
Click to expand...
word "manfred" to the first 10 lines in the message
 
MANFRED

No that doesn't work here is what I have

Expr1: [Address] &vbcrlf &[FIELD6]

and It thinks that vbcrlf is a field
Click to expand...

you have to be a little bit more precise when you ask a question:
I have assumed you are taking about VBA

vbCrLf is a synonym in VBA for CHR(13) &chr(10)

a "Carriage return" and a "line Feed"

in a field you have to use the CHR()

BTW: the magic word is only for e-mails, I scan the first 10 lines for
this word, before I download any message for this account
 
MANFRED

No that doesn't work here is what I have

Expr1: [Address] &vbcrlf &[FIELD6]

and It thinks that vbcrlf is a field

any other ideas
-----Original Message-----


field1 &vbcrlf &field2
Click to expand...
word "manfred" to the first 10 lines in the message
MW
.
Click to expand...
Click to expand...

Your doing this in an Access query, so you cannot use a VBA constant.
Use:
Expr1: [Address] & chr(13) & chr(10) & [FIELD6]
 
Back
Top