Null values from sql server to access

[mcgrcoAgain]

Hi there,

I'm using a passthrough query to get information from sql server. Unfortunatly when I try to append a field to a local access table I get validation errors as the field is blank. The table is set up to allow nulls but I think the sql field has some other type of null init.

Ive tryed isempty, isnull, nz and if column " ", "", column and none of this works. I can link it as a table as when the tqable is open in access it prevents the c++ application writing to sql server.

Any ideas wqhat i can do?

Much appreciated

 

[mcgrcoAgain]

Thanks for your reply Pat. The field is text and I already changed the table properties to AZL and set the required field to No. Its still an issue unfortunatly

 

[Banana]

Are you sure that the SQL server's table allows Nulls for that field?