Hello,

On a report I would like the purchase price to display beneath the date purchased. I had decided to concatenate the fields so that they will not be affected if other fields in the record contain several lines. However; the currency formatting is lost when the fields are combined in this manner.

Control Source of calculated text box is as follows:

=[DatePurchased] & "

" & [PurchasePrice]

Similarly, I wanted the email address to display beneath the URL field:

=[URL] & "

" & [Email Address]

But it ends up looking like this:
www.example.com#http://www.example.com# (http://www.example.com#http://www.example.com#) or #http://www.example.com#

And email like this:

sample@sample.com#http://www.sample@sample.com#

I imagine there is something else that needs to be added to the expression to fix the formatting?

Thank you in advance.

G

Access doesn't support variable formatting without a third party add in.

Thanks Rich;

Can you recommend an add-in?

G

Rich Text Control comes with ODE, an alternative is available from FMS Components. http://www.fmsinc.com/products/memo/index.html

[This message has been edited by Rich (edited 03-26-2002).]