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

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" <alecgreen DeleteThis @hotmail.co.uk> wrote in message
news:1186565067.640959.137530@d55g2000hsg.googlegroups.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