Format not working

[SitesMasstec]

Hello collegues!

I have a Grid in a form with many columns. One of the columns is to display a numeric value, but it is not formatting values in that column.

Please see the design and then the form being executed:




Neither it is centering text:



What is wrong?

Thank you.

 

[kiyo]

The alignment setting is a property of the column, not the text.

 

[SitesMasstec]

Nice Kiyo, thenk you.

And what about the number formating? I need 1450,00 to appear 1.450,00 . I just don't understand why the data does not obey the Format property.

 

[kiyo]

You can solve this by using INPUTMASK instead of FORMAT.

 

[SitesMasstec]

Hello Kiyo!

I put 9,999,999.99 in the InputMask in the Text property, and it displays pontuation only for cents, not for thousands.

But then I changed to the Column property (as you had told in a post above about Alignment setting) and it works fine.

Thank you!

 

[mjcmkrsr]

Hi,

You have to check your setting of SEPARATOR in Tools - Options - Regional and even may have a look at the help file under : SET SEPARATOR

hth

MarK

 

[SitesMasstec]

Hello Mark!

Yes, the settings are correct for the currency in my country, but I know I have to use 9,999,999.99 inside Properties, and the settings display correcty a value, i.e. 1.234,50.

 

[kiyo]

I have written 999,999.99 in the inputmask of the column properties.

 

[mJindrova]

This is example for decimal separator "." and space for thousend and milions.