join contents of text boxes

[alecgreen]

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

 

[Allen Browne]

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