If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
how to enter CR in report
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: web: http://www.artabel.com ======================================= |
#2
|
|||
|
|||
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 wrote in message ... 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: web: http://www.artabel.com ======================================= |
#3
|
|||
|
|||
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: web: http://www.artabel.com ======================================= "Arvin Meyer [MVP]" wrote in message ... 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 wrote in message ... 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: web: http://www.artabel.com ======================================= |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Create a form to enter report criteria | Flying Blind | General Discussion | 2 | August 18th, 2005 07:13 AM |
Reports with Date Range - Errors | jwr | Setting Up & Running Reports | 12 | August 8th, 2005 12:57 PM |
Enter Parameter Value to select criteria for a report | Barnie | Setting Up & Running Reports | 1 | August 6th, 2005 02:03 AM |
Form to Enter Report Criteria works, but Query won't run from Macr | BARKAROO | Using Forms | 1 | October 16th, 2004 08:13 PM |
Display Parameter from Form on Report | sara | Setting Up & Running Reports | 10 | July 19th, 2004 04:54 PM |