Two Decimal Place Zero is being truncated

Two Decimal Place Zero is being truncated

  
I have an Advance Query with an Output structure of Type Decimal that I will assigned to a Textbox not Expression.
Ex. Actual value in the SQL Database is 1500.00000
But when I use Advance Query to retrieve it the  value it displays 1500.0, even when i use ROUND(1500.0,2) it still truncate the zero.
Is there any way to display it to 2 decimal 1500.00 since we are talking about Money.
Michael,

You can use the FormatDecimal built-in function for it, when assigning to the TextBox

Best regards,
PC
I dont think that will work since the Variable(Textbox) is Type Currency...Format Decimal will only work for Text Data Type
Michael,
You can use FormatCurrency instead. It takes a currency type and presents/outputs text formatted the way you want.
Michael,

There is no type currency for a Textbox, you can only set Text, Number, Email or Search.

If you are talking about the variable that holds the value of the Textbox, if it's Currency you can use FormatCurrency instead.

Best regards,
PC
But then you need to "fix" the query and or create a new variable.

seems a bit vague, since tons of applications use currency (it makes the world go around)