InfoPath Dev

I'd like ot be able to format any currency field in my form to the currency picked from a drop down list.

I've been using the sample template "Expense Report International" which does a simular thing but this template just changes the text that appears on the field label. Is there a way to actually reformat the currency of a numeric field?

Hi Taffman,

Have you tried using conditional formatting rules to do this?

http://office.microsoft.com/en-ca/assistance/ha011227821033.aspx

You should be able to do what you want with conditional formatting as you would just test for the value of the selection they have made in the drop down list and then format accordingly.

I dont think this will help. All conditionally formatting will do is format colour or font. I need to change the currency type from example from a default e.g. €0.00 to $0.00 based on currency selection?

I'm sorry, I thought I had seen within the conditional formatting that you could format the number that way. I know there is an easy way to do this, I'll post back if I can find it.

Ok many thanks for your time.

This HowTo might be of some help:

http://infopathdev.com/howto/tutorials/default.aspx?i=53cd5122167448daa4d85ef4e5c2ae51

What you'll do is load all of the currency symbols into your data source and display the appropriate one in the expression box next to the numerical value on your form.

Let us know if you have any questions!

This is really useful, many thanks.