Member Avatar for nice_true

Hi!
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?

Thanks,

  • 2 Contributors
  • 1 Reply
  • 104 Views
  • 12 Hours Discussion Span
  • Latest Post Latest Post by manal
Member Avatar for manal

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
        Next
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.