Update query to replace blank fields with Null

[mainerain]

Is it possible to replace blank fields with null in an update query via query design?

Alternately, how would i write an IIf using (Is Not Null) AND (does not contain a blank field)? I want to write only if the field is not blank and is not null.

Thanks

[Gicu]

In Access blank is (usually) Null. You also have the Zero Length String "" which is not the same and some use erroneously in VBA to make a control look blank:

Me.txtMyControl="" 'Should actually use Me.txtMyControl=Null

.

So maybe you can explain what you really need to do with this query. If you do have a bunch of records that have a ZLS in a field simply put that (="") in the "Criteria:" row in query design and use Null in the "Update To:" row.

Cheers,

[mainerain]

use Null in the "Update To:" row ---- PERFECT! thanks

[Gicu]