4 Replies Latest reply: Apr 2, 2011 4:40 AM by Niall O'Donovan RSS

    Subform multi-currency


      Hi I would use multicurrency subform but I could not find the right way, I used a combo to change the location of the subform but only changes the first value, could someone please help me.


        • 1. Re: Subform multi-currency
          Niall O'Donovan Community Member



          There is an example here: http://assure.ly/e59VGu.


          The first page changes the locale of target objects individually.


          The second page adapt's Paul's function to change the locale of all of the objects in a container.


          Hope that helps,



          • 2. Re: Subform multi-currency
            richardmesenV Community Member

            This example is needed, I could solve my problem.

            Thank you very much

            • 3. Re: Subform multi-currency
              mmgiath Community Member

              Hi Niall,

              Is it possible you explain to me what locale is?

              Also the currency number into the cost field how come up any time you select a current from DDList?

              I do not see you have these numbers somewhere in your scripts.


              Thank you

              • 4. Re: Subform multi-currency
                Niall O'Donovan Community Member



                From the Help in LC Designer:


                A locale is a standard term used when developing international standards to identify a particular nation (language, country or region). For the purposes of FormCalc, a locale defines the format of dates, times, numeric, and currency values relevant to a specific nation or region so that users can use the formats they are accustomed to.



                When developing a form you would generally set the locale for the form in the File > Form Properties > Defaults tab.


                LC Designer Locale 01.png


                You would either set it to a specific locale (language/country) or to "Viewer's system locale". The second option means that when the form is opened the numbers, dates, etc. will be displayed as per the user's preferences.


                As wll as setting the default locale at design time, you can also set the locale of individual objects in the Object > Field palette and hit the Patterns button:


                LC Designer Locale 02.png


                For the most part you would set the locale at design time in LC Designer.


                However there may be times where you want the user to be able to change the locale at runtime and this is what the example is demonstrating.


                In the example the cost field has a default value set in the Object > Value palette and this is why you don't see it in the script.


                Hope that helps,



                Assure Dynamics