Servoy Forum

I am trying to setup a text box to allow the user to enter a currency; while this works fine with $#,##0.00|#0.00 in an AG Grid, when using a 'Field' or a 'TextBox' web component I get the same results as in this previous topic:
viewtopic.php?f=22&t=9659

Unlike the AG Grid which has an edit format and a display format, the text box/field in a form only has a display format and a placeholder. So trying to enter 25 into the TextBox will display $250.00.

This surely must be possible; does anyone know how currency entry works in a form's text box/field?

For anyone else who gets caught up in this; the ability to have an edit format as well as a display format only appears if the data provider is type Number.