I am inserting text in a table which contains date field.
In some of the entered records, the date field is to be left blank.
By default, it enters something like "1/1/1900".
Now I wish to display data from this table into a datagrid.
For the records in which the default date specified above is entered, I wish to display the character "#".

Is this possible?
If yes, then how?


yes it is possible

num = Me.DataSet11.Your_Table_name.Count  
        For i = 0 To num - 1
            If Me.DataSet11.Your_Table_name(i).Item("date")="1/1/1900"  then 
              Me.DataGrid1.Item(i, Column_index) = "#"
            End If