Newbie Questions

Re: Field Format on drop down list selection

Taffman — Thu, 27 Apr 2006 08:15:06 GMT

This is really useful, many thanks.

Re: Field Format on drop down list selection

Matt Faus — Wed, 26 Apr 2006 19:26:48 GMT

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!

Re: Field Format on drop down list selection

Taffman — Wed, 26 Apr 2006 17:22:31 GMT

Ok many thanks for your time.

Re: Field Format on drop down list selection

Ted Fitch — Wed, 26 Apr 2006 17:03:35 GMT

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.

Re: Field Format on drop down list selection

Taffman — Wed, 26 Apr 2006 16:47:53 GMT

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?

Re: Field Format on drop down list selection

Ted Fitch — Wed, 26 Apr 2006 15:42:56 GMT

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.

Field Format on drop down list selection

Taffman — Wed, 26 Apr 2006 14:25:50 GMT

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?