inserting NULL value 1

[wbodger]

I have this code

if IsNull(tempFrmInstr) or IsEmpty(tempFrmInstr) or (tempFrmInstr = "") then
tempFrmInstr = ""

but rather than

tempFrmInstr = ""

can I just do

tempFrmInstr = NULL

to place a null value into that field? It is a nullable field, so I think it should work.

wb

 

[ChrisHirst]

Yes.

Chris.

Indifference will be the downfall of mankind, but who cares?
Time flies like an arrow, however, fruit flies like a banana.
Webmaster Forum

 

[wbodger]

thx