DataGridColumnStyle Format Property

[Guest]

One of the columns of my datagrid is an account #. The actual field which is
coming from a sql server database is defined as a character. Within the
database the account # 200300001 come across in our financial system as
20030000.1. How do I define a character field format, as an example
(XXXXXXXX.X), in the datagridcolumnstyle format property using the designer?
Currently I can format numeric fields in the a datagridcolumnstyle format
property with, as an example, "###,##0.00".
Thanks in advance.

 

[Otis Mukinfus]

One of the columns of my datagrid is an account #. The actual field which is
coming from a sql server database is defined as a character. Within the
database the account # 200300001 come across in our financial system as
20030000.1. How do I define a character field format, as an example
(XXXXXXXX.X), in the datagridcolumnstyle format property using the designer?
Currently I can format numeric fields in the a datagridcolumnstyle format
property with, as an example, "###,##0.00".
Thanks in advance.

{0:00000000.0} AFTER you convert it to a number, but I don't think you can
convert it to a number in the designer. There's probably an event you can catch
that will allow you to do special formatting.

Otis Mukinfus
http://www.arltex.com
http://www.tomchilders.com