Creating :Null field in Make Table Query

[Leslie]

In Access 97, if I created a query that included a :Null field, (Example -
SKU: null)when I ran the Make Table query, it created a Text field called SKU
in the Table. In Access 2002, if I do the same thing, it creates a binary
field in the table. Does anyone know of a way to create a null, text field
in Access 2002?

Thanks,
Leslie

 

[Allen Browne]

Yes, JET 4 is certainly less intelligent at guessing data types than
previous versions were.

You can use an IIf() expression to give JET a clue about the data type:
IIf(False, "", Null)
The False part is never true, so it always returns Null, but the presence of
the alternative is enough to indicate the field type is meant to be text.