control source in text field

[drfever]

I'm trying to add data from a table into a text statement.

The text box works with the first data source but gives a syntax error when attempting to add a second.

My text box looks like this:

="thanks for your interest in" &[address] ". If my office can be of any assistance please contact" & [telephone] "."

How can I add several pieces of data to one text box.

thanks

 

[79ssecca]

="thanks for your interest in" &[address] ". If my office can be of any assistance please contact" & [telephone] "."

Should be...


="thanks for your interest in" &[address] & ". If my office can be of any assistance please contact" & [telephone] & "."


Have fun
ssecca

 

[drfever]

thanks for the help.

However, it has brought a new question..........
On another report I want to insert a $ amount into my report from the table.
The field in the table is currency but inserted into the report as text.

How can I take a currency field insert into a text box and still show it as a currency or % ??


Thanks