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
|
|||
|
|||
Concatenate form fields and include linefeed
Access 2003 Question. I want to concatenate some table fields into a single text field in a report. Basic concatenation works OK but I cannot get linefeeds to work. Every way I try I just get square boxes and no line feeds. Will very much appreciate it if I can get either confirmation that it can't be done or preferrably how to achieve. -- Regards, OssieMac |
#2
|
|||
|
|||
Concatenate form fields and include linefeed
I feel foolish when I have posted a question and the answer comes to me
later. Just had to get the code the correct way around. Chr(13) & Chr(10). I had them reversed. -- Regards, OssieMac "OssieMac" wrote: Access 2003 Question. I want to concatenate some table fields into a single text field in a report. Basic concatenation works OK but I cannot get linefeeds to work. Every way I try I just get square boxes and no line feeds. Will very much appreciate it if I can get either confirmation that it can't be done or preferrably how to achieve. -- Regards, OssieMac |
#3
|
|||
|
|||
Concatenate form fields and include linefeed
I find it easier to remember the VBA constant, vbNewLine
"First Line" & vbNewLine & "Second Line" yields First Line Second Line -- There's ALWAYS more than one way to skin a cat! Answers/posts based on Access 2000/2003 Message posted via http://www.accessmonster.com |
#4
|
|||
|
|||
Concatenate form fields and include linefeed
That works fine in VBA and I use it myself but when concatenating table
fields into a form or report textbox it is not recognized. -- Regards, OssieMac "Linq Adams via AccessMonster.com" wrote: I find it easier to remember the VBA constant, vbNewLine "First Line" & vbNewLine & "Second Line" yields First Line Second Line -- There's ALWAYS more than one way to skin a cat! Answers/posts based on Access 2000/2003 Message posted via http://www.accessmonster.com . |
Thread Tools | |
Display Modes | |
|
|