Format numbers in a string

[fredpeters555]

I have a data string inside a control that contains text as well as field data. I would like to format currency, % and dates within the string. It is as follows: =Sum([Expr1]) & " or " & ([text5]/[text6]) & " % " & "of Inventory has not moved since " & [dMoveDate] . Expr1 is currency, ([text5]/[text6])is % and [dMoveDate] obviously is date.
TIA!
Fred

 

[GingerR]

look up the FORMAT function in help:

=format(Sum(Expr1),"Currency&quot & " or " & format(([text5]/[text6]),"0.0%&quot & " of Inventory has not moved since " & format(dmovedate,"m/d/yy&quot

totally off the topic: it might be better if you rename your fields. for example, ChargeAmount is more descriptive than Expr1....just a thought....

 

[fredpeters555]

Thanks for the help. It worked very well for me. I did search out help on the FORMAT before I posted but it muast have been just in Access as opposed to VBA. Thanks for the tip on the Expr1 rename. Sloppy practice I've had since starting.

Fred