Displaying decimal values in input box

Orlando Mota

Question

I need to display a value showing 2 decimal places (eg. 24.30) returned from a query on a table column that is defined with 2 decimal places, and if possible right aligned in the input box.

What's happening now for example is that the 24.3 is displayed. The need arises from the fact that these values represent money.

Any suggestions.

26 Oct 2004

Miguel Seabra Melo

Dear Orlando,

If you configure your data model to have 2 decimal places you should have two decimals showing on the inputs without any additional formatting. This is not the case only when the rightmost decimal digit(s) is/are zero. In this case, you are correct, they do get prunned: this is because our data model is designed to disregard non-significant decimal places. While in the case of Expressions you can use the FormatDecimal() Built-in function, there is no provision for this kind of formatting on Input-targetted values.

In regards to aligning right, you should select "Extended Properties" for the Input widget and add the style property with the value "text-align: right"

Best Regards,

Miguel

27 Oct 2004

1 reply

28 Oct 2004

Show thread

Hide thread

Orlando Mota

Thanks Miguel

28 Oct 2004

Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.

See the full guidelines