Problem when Reading directly from MS Access

ta5

Hi

I want to read directly from MS Access, but there is a problem with integer fields:

if Recordset.fields.item('ct').value = 0 then

This code does not compile because the ffw. error:
Type conversion is not possible because 1 of the operators contains an invalid type...

I've also tried with Format-Method, also with no success?

Any ideas for that?

Thanks in advance

Thomas

danlindstrom

one suggestion is to treat all responses as text

if Recordset.fields.item('ct').value = '0' then

ta5

danlindstrom wrote:

one suggestion is to treat all responses as text

if Recordset.fields.item('ct').value = '0' then

This works, but it is quite tedious:

IF FORMAT(Recordset.Fields.Item('ct').Value) = FORMAT(0) THEN BEGIN