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
|
|||
|
|||
join contents of text boxes
Hi
I have three text boxes on my report, which I would like to 'join' together, for example... text box 1 = "abc", text box 2 = "def", text box 3 ="ghi" The result I am after is "abc def ghi" - I have tried =[text box 1] & " " & [text box 2], which does work but when I try =[text box 1] & " " & [text box 2] & " " & [text box 3] it fails to show anything! Any ideas please Alec |
#2
|
|||
|
|||
join contents of text boxes
Provided you have the 3 text boxes on your report, and you have their names
correct, your expression should work. If it doesn't there may be something wrong with the database. Uncheck the boxes under: Tools | Options | General | Name AutoCorrect In Access 2007, it's: Office Button | Access Options | Current Database | Name AutoCorrect Explanation of why: http://allenbrowne.com/bug-03.html Then compact the database: Tools | Database Utilities | Compact/Repair or in Access 2007: Office Button | Manage | Compact/Repair -- Allen Browne - Microsoft MVP. Perth, Western Australia Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org. "alecgreen" wrote in message oups.com... Hi I have three text boxes on my report, which I would like to 'join' together, for example... text box 1 = "abc", text box 2 = "def", text box 3 ="ghi" The result I am after is "abc def ghi" - I have tried =[text box 1] & " " & [text box 2], which does work but when I try =[text box 1] & " " & [text box 2] & " " & [text box 3] it fails to show anything! Any ideas please Alec |
Thread Tools | |
Display Modes | |
|
|