So many good reasons to either not use datagridviews for data entry or to use a 3rd party grid that has more capability BUT



Suppose I need to use a standard MS datagridview with a BBS.



I can set the format to d for a short date but in BO mapper I use either generic for nulls or #1/1/1800# for replace/value.



Either way, as soon as you enter a date field in grid you get 1/1/1800. Then if you enter an invalid date it throws an error.



Any tricks for using the datagridview? Ideally I'll like to have the datetimepicker in that column, but I'm a bit of an idiot as to how to build the grid manually if I do that and it seems pretty labor intensive since you can't just pick that as a control type for the column.



Suggestions? Doesn't have to be fancy, just user friendly for entering dates



( next time around I'll be using an infragistics grid where I think there are more options )



TIA