Numeric format question

[amerkfan]

I am reposting this one, as I am still trying to figure this one out. I am trying to set up a form where the numeric format of one field is based on units of measure in another field. The fields are: units1 and iq1. What I want to do is have the iq1 field format for percent with two decimal places when units1 is  LS or ls or L.S. or l.s. otherwise the field should be formatted for a number with the format nnn,nnn,nnn.nn. Any help for this newbie is appreciated.

[Niall_O_Donovan]

Hi,

I would be inclined to have a dropdown for the units, rather than leave it to the user to type in the units.

This will make it easier to script the main part of your question.

Here are some examples for changing the display pattern at runtime: http://assure.ly/rZQIhn and http://assure.ly/e59VGu.

Hope that helps,

Niall