NULL representation in TCRDBGrid

[[email protected]]

Hi.

Is it possible to display, in TCRDBGrid, any custom string instead of 'NULL' value? I'd like to show, e.g text '' in cells, where is no value.

Regards,

Wojto

[bork]

Hello

You can use the OnDrawDataCell event to define your own drawing method. In this method you should write required value to the cell if field value is NULL:
begin
if Field.IsNull then
// write required value to the cell here
else
TCRDBGrid(Sender).DefaultDrawDataCell(Rect, Field, State);
end;

[[email protected]]

It's working. Thank you for your help.

Regards