how to enter CR in report

[Guest]

Hello,

In access I created a form to print out labels from our dbase.
I want to build one string from information in the dbase
i.e.
=Trim([Aanspreking] & " " & IIf([Voornaam] Is Null;"";Left$([Voornaam];1) &
". ") & UCase$([Naam])) & Chr$(13) & ..............

The strim contains several lines. How can I create a "new line" with this
syntax?
CHR$(13) or CHR(13) (the ascii code for control return) does not seem to
work

any other suggestion?

tia,
bart



--

=======================================
ARTABEL
Bart Plessers
Schreursvest 67
3001 Leuven
BELGIUM
tel +32 (16) 23.40.85
tel +32 (16) 28.40.03 (rechtstreeks)
fax +32 (16) 23.41.06
email: (e-mail address removed)
web: http://www.artabel.com
=======================================

 

[Arvin Meyer [MVP]]

You must use a concatenation for Carriage Return and Line Feed like:

Chr(13) & Chr(10)
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access

 

[Guest]

thanx a lot!


--

=======================================
ARTABEL
Bart Plessers
Schreursvest 67
3001 Leuven
BELGIUM
tel +32 (16) 23.40.85
tel +32 (16) 28.40.03 (rechtstreeks)
fax +32 (16) 23.41.06
email: (e-mail address removed)
web: http://www.artabel.com
=======================================

You must use a concatenation for Carriage Return and Line Feed like:

Chr(13) & Chr(10)
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access

Hello,

In access I created a form to print out labels from our dbase.
I want to build one string from information in the dbase
i.e.
=Trim([Aanspreking] & " " & IIf([Voornaam] Is Null;"";Left$([Voornaam];1) &
". ") & UCase$([Naam])) & Chr$(13) & ..............

The strim contains several lines. How can I create a "new line" with this
syntax?
CHR$(13) or CHR(13) (the ascii code for control return) does not seem to
work

any other suggestion?

tia,
bart



--

=======================================
ARTABEL
Bart Plessers
Schreursvest 67
3001 Leuven
BELGIUM
tel +32 (16) 23.40.85
tel +32 (16) 28.40.03 (rechtstreeks)
fax +32 (16) 23.41.06
email: (e-mail address removed)
web: http://www.artabel.com
=======================================