Forums Ultimate UI for Windows Forms
Your Privacy Matters: We use our own and third-party cookies to improve your experience on our website. By continuing to use the website we understand that you accept their use. Cookie Policy
Close
David
265
Entered Double / Currency values vs Displayed Values
posted

Hi;

I have a basic understanding of the gird column's Style and MaskedInput properties.  In relation to double and currency values, my values are always stored as double in the database.

However, is there away to mimic MS Access behaviour whereby I can

  • Enter the data in a double format (e.g. 9999.4476) without prompt characters then;
  • Display the cell (when not active) in a fixed format e.g. 2 decimal places (i.e. would display 9,999.45).

If this can be achieved, any code example would be appreciated.

Kind Regards

Dave

  • 69832
    Verified Answer
    Offline posted

    davidba65 said:
    Enter the data in a double format (e.g. 9999.4476) without prompt characters

    No, we don't have anything that does character validation without masking

    davidba65 said:
    Display the cell (when not active) in a fixed format e.g. 2 decimal places

    Yes, set the column's Format property to (for example) "#,###.00"