Highlighted

Changing Display Patterns dependent on other fields

Avatar

30-01-2009

Hello,



Is it possible to change the display format of one field depending on what is selected/entered in another field?



I.e. we offer two types of discounts, a percentage and a monetary. One requires the zz.zzz% and the other a $zzz.zz format. The display pattern will depend on another field which the user indicates which form of discount is being applied. I would like to combine this all into one field. Is this possible?



I've tried the Format() function, but am having trouble with it.



Thank you for your help.



-Robinson