how to add a null string in a access database

[kindjal]

hi,

i would like to know if we can assign a null string value (ie "") into a field of an access 97 or 2000 database ?

thank for your help

[Lothar Haensler]

yes, you can.
if you use a recordset object:
rs.fields(fieldIndexOrNumber).Value = NULL
(assuming that your field is nullable in the table.

[Kyle Burns]

This wouldn't insert an empty string, though. The difference between NULL and an empty string is huge when you're running a query. I think the answer that's being looked for this time is:

rs(fieldIndexOrNumber) = vbNullString

[kindjal]

cool, that's what i need, thanx