Skip to Content
avatar image
Former Member

dynamically change the pattern of numeric field in adobe

I am using a adobe form to display Sales order ouput.

I have a requirement that for some kind of sales order the quantity field should be displayed with 2 decimal places and for some with 4 decimal places.

So i have made the field in the form with display pattern = z,zzz,zzz,zz9.99

and writing a FromCalc script as below.

if ( z_mix eq "X" ) then

Format ("z,zzz,zzz,zz9.9999", data.MainSubform.ItemTable.ItemGroup.Items.KWMENG.value)

endif

i also tried

if ( z_mix eq "X" ) then

data.MainSubform.ItemTable.ItemGroup.Items.KWMENG.format = "z,zzz,zzz,zz9.99"

endif

The problem is i am not able to understand what statement to be used to change the format of a numeric field.

When i replace the second code with

data.MainSubform.ItemTable.ItemGroup.Items.KWMENG.presence = "hidden"

this functionality works. Which means i need to correct statement for pattern change of a numeric field.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    Jul 29, 2009 at 04:51 AM

    Or if somebody can provide me with alternative solution is also welcom.

    My requirement is a quanity field in the adobe form would be displaying either with 2 decimal place or 4 decimal place based on some condition.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jul 29, 2009 at 10:40 PM

    I found the answer to this from ADOBE forum for Livecycle forms.

    We need to use

    numericfield.format.picture = "zz,zzz,zz9.9999"

    Add comment
    10|10000 characters needed characters exceeded