carriage return in an expression

[Dave]

Using Access 2000, I'm looking for a way to concatenate two fields in an
expression within a report. Basically, the two are an address field (memo
type) and postcode (text). I know about the expression itself and use the
syntax =[Address]&" "&[Postcode] but ofcourse, the postcode appears on the
same line as the last line of the address. What I really want to be able to
do is to have it on the next line. I could use a separate control, but if
the address is only 2 lines long, there is a gap. Any ideas gratefully
received.

Dave

[Deano]

Dave wrote:

Using Access 2000, I'm looking for a way to concatenate two fields in
an expression within a report. Basically, the two are an address
field (memo type) and postcode (text). I know about the expression
itself and use the syntax =[Address]&" "&[Postcode] but ofcourse, the
postcode appears on the same line as the last line of the address.
What I really want to be able to do is to have it on the next line. I
could use a separate control, but if the address is only 2 lines
long, there is a gap. Any ideas gratefully received.

Dave

=[Address]& vbCrLf &[Postcode]

[Pieter Linden]

"Dave" <no****@yourbusiness.com> wrote in message news:<41***********************@ptn-nntp-reader01.plus.net>...

Using Access 2000, I'm looking for a way to concatenate two fields in an
expression within a report. Basically, the two are an address field (memo
type) and postcode (text). I know about the expression itself and use the
syntax =[Address]&" "&[Postcode] but ofcourse, the postcode appears on the
same line as the last line of the address. What I really want to be able to
do is to have it on the next line. I could use a separate control, but if
the address is only 2 lines long, there is a gap. Any ideas gratefully
received.

Dave

vbCrLf? or I think it's chr$(16) & chr$(34)

[Douglas J. Steele]

"Pieter Linden" <pi********@hotmail.com> wrote in message
news:bf**************************@posting.google.c om...

"Dave" <no****@yourbusiness.com> wrote in message

news:<41***********************@ptn-nntp-reader01.plus.net>...

Using Access 2000, I'm looking for a way to concatenate two fields in an
expression within a report. Basically, the two are an address field (memo type) and postcode (text). I know about the expression itself and use the syntax =[Address]&" "&[Postcode] but ofcourse, the postcode appears on the same line as the last line of the address. What I really want to be able to do is to have it on the next line. I could use a separate control, but if the address is only 2 lines long, there is a gap. Any ideas gratefully
received.

Dave

vbCrLf? or I think it's chr$(16) & chr$(34)

Chr(13) & Chr(10), and it must be in that order

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

[Roald Oines]

Douglas J. Steele (NOSPAM_djsteele@NOSPAM_canada.com) wrote:
: "Pieter Linden" <pi********@hotmail.com> wrote in message
: news:bf**************************@posting.google.c om...
:> "Dave" <no****@yourbusiness.com> wrote in message
: news:<41***********************@ptn-nntp-reader01.plus.net>...
:> > Using Access 2000, I'm looking for a way to concatenate two fields
:> > in an expression within a report. Basically, the two are an
:> > address field (memo type) and postcode (text). I know about the
:> > expression itself and use the syntax =[Address]&" "&[Postcode] but
:> > ofcourse, the postcode appears on the same line as the last line
:> > of the address. What I really want to be able to do is to have it
:> > on the next line. I could use a separate control, but if the
:> > address is only 2 lines long, there is a gap. Any ideas gratefully
:> > received.
:> >
:> > Dave
:>
:> vbCrLf? or I think it's chr$(16) & chr$(34)
:
: Chr(13) & Chr(10), and it must be in that order

I use vbNewLine myself...
--
Please remove the under_scores if sending me mail.

[Larry Linson]

"Roald Oines" wrote

: Chr(13) & Chr(10), and it must be in that order

I use vbNewLine myself...

Like vbCrLF (which gives the identical actual character codes), vbNewLine
can only be used in VBA code. If using an expression in a Control Source,
for example, you must use the Chr(13) & Chr(10) that the vbCrLf or vbNewLine
would generate in VBA code.

Larry Linson
Microsoft Access MVP