Can you concatenate Memo Fields?

[TLiberty]

Is it possible to have a memo field and then concatenate it with any data type variables?<br>

 

[rhicks]

Sure you can.<br>
<br>
= yourMemo & &quot; &quot; & yourText & &quot; &quot; & yourNumber<br>
This comes out as a text string.<br>
<br>
Hope this helps<br>
RDH

 

[jmckeon]

I have the same problem -- I'm using access 97 and it doesn't work. I am trying to concatenate a memo field with a couple of text fields and number fields on a form. E.g. - I want to take a product description and pricing field and combine them like =[ProductDescription]& &quot; costs &quot; & [ProductPricing]. All I get is &quot;#Error&quot;. Anyone know how to do this?

 

[tlbroadbent]

jmckeon ,

Please create a new thread for your question rather than appending to a long dead thread. Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.