Retrieve formatted value from a DateTime column

[Deborah]

I am calculating the required width of my columns. The DateTime columns are all coming out too large because the .Value property of the field is the full date and time, even though the column is formatted to be the short date.

How do I get the formatted value of the column?

Thanks -

[Emanuel Varga]

Hello Deborah,

Again, please let's move this move on with this discussion on this thread, i believe an universal solution would be better than a specific one.

Best Regads,
Emanuel Varga

[Deborah]

The short answer to this question is that you cannot get the formatted value of the column EXCEPT in the CellFormatting and RowFormatting events.

For more information see the link that Emanuel provided.