I've got a datagridview populating from a database and, there's no way around it, the database will sometimes return null values in a boolean column, and I get the following error:

The following exception occurred in the DataGridView:

System.FormatException: Value '' cannot be converted to type 'Boolean'.
at System.Windows.Forms.Formatter.FormatObject(Object value, Type targetType,
TypeConverter sourceConverter, TypeConverter targetConverter, String formatString,
IFormatProvider formatInfo, Object formattedNullValue, Object dataSourceNullValue)
at
System.Windows.Forms.DataGridViewCell.GetFormattedValue(Object value,
Int32 rowIndex, DataGridViewCellStyle& cellStyle, TypeConverter valueTypeConverter,
TypeConverter formattedValueTypeConverter, DataGridViewErrorContexts context)

To replace this default dialog please handle the DataError event.
I tried handling this in the Cellvalidating event, but it didn't work. How do I actually catch those nulls before they cause an error?