Ask which type of field is returned

  • Thread starter Thread starter Gina
  • Start date Start date
G

Gina

I was too quick... when I said it works

If it is empty and type of string then ""
If it is empty and type of currency then 0
....
If rst.Fields(i).SourceField = rst.Fields(i).Type("String")
Then

tried all kind of variations ... but do not seem to be on the right track

oh dear ....
Gina
 
What I am trying to achieve with this is to find out whether the field is of
type date ....

If Not IsNull(arWords) Then
rst.Fields(i) = arWords(i)
End If

and then I will have to add something or change something at arWords(i)

I always get error message re data conversion .. I can change the table to
be string but ....

Gina
 
Back
Top