Num Pattern in Picture Clause Specification

[Former Community Member]

Even after reading LC Designer help and Picture Clause Specification I am still not clear what would be a proper numeric pattern as per client's request below.

The value should be displayed with all significant digits. i.e. 0.05, 1.5, 5.555.

If they enter 1.95 the form shows the rounded value to the whole number 2. I cannot find out the way to show what is entered like 1.95 in the format 999.999 less insignificant digits. Also, is it possible to show period instead of coma in the patter. I have tried 999V999, but still shows coma.

Any help would be greatly appreciated.

Thanks,

[Niall_O_Donovan · Accepted solution]

Hi,

In the Picture Clause, 'z' will display a single digit, if it exists. Therefore a pattern like this should work:

num{zzz,zz9.9zzzzz}

In relation to the period instead of a coma, you could select the Danish locale for that object (again in the Patterns dialog). See example here for changing at runtime which will just show you some of the patterns that you can then apply in your design / pattern: http://assure.ly/e59VGu.

Hope that helps,

Niall

[Former Community Member]

Thank you Niall. Sample form is great btw.