How we can recognize an empty value of ms access field.


suppose :

here empVal = "" and empVal1 = "" i. e. in the database there are no value i.e. empty

so if i wrote

here value should show "1"

But it is not entering within the if condition.

So, how can we evaluate the value of empty

Try testing for a NULL value as well as an empty string.

what i normaly do if i know when a value can be null
is

Dim empVal, empVal1, num
num = 0
empVal = Recordset.Fields.Item("subj").Value & ""
empVal1 = Recordset.Fields.Item("org").Value & ""

so you allways have a empty string value

That logic is dangerous in general. You can get away with it in certain languages, but you'll find yourself scratching your head when rs("field1") & "" comes back null as you move ahead. It's also confusing to programmers who come in behind you and have to decide what your intent was by concatenating a zero length string to a random field.

But then, I'm nitpicky like that.

True , True
Normaly i would use
String.IsNullOrEmpty(y) in .Net
or in VB IsEmpty(x) / IsNothing or IsNULL depending what i was expecting

but in his example he's allready assigning it to a non specified value
' Dim empVal, empVal1, num
without perceding check (so i thought what the heck)
and afterwords he's checking on an empty string
' If ( (empVal = "") AND....

if this is his check, my previus example will work
And if you ask out recordset("Name") & ""
and the rs is Null it will return "" in VB
if rs isn't nothing
don't know if it will do the same in C++