Is there a mode for the date columns within the grid where I can enter plain text into the cell (rather than using the input mask)?
So, what I'm looking to do is to be able to type in
16th April 2010
or
16/04/2010
and have it convert this correctly to a date value.
likewise for any other string format that Convert.ToDateTime would convert successfully to a date based on the locale
Obviously if I type in:
Wibble dribble
then I'd expect it to throw a data error.
I would still like to have the drop-down available to select a date
Cheers
Alan
Hi Alan,
What you can do is place an UltraCalendarCombo control on the form with the grid. Then set your DateTime column(s) EditorComponent property to this control.
The UltraCalendarCombo has no masking, it allows freeform text input for dates.
Note, however, that your example of "16th April 2010" does not work. If you try calling Convert.ToDateTime on such a string, it will raise an exception - or at least it does on my machine with US regional settings. A string like "16 April 2010" works, though. :)