[AccessD] A little Null Help Please

Joe Hecht jmhecht at earthlink.net
Sat Feb 11 22:52:24 CST 2006


I have a situation where for some records there is no DOB
for an entry.

 

The details are messy but trying to be a good programmer I
am trying to code around it.

 

If DOB = Null Then

    txtAgeThisDay.Value = "No Dob"

    Else

    txtAgeThisDay = yearcalc(DOB, txTaCCIDENT_dATE) 'Calc
Age on Event Day

  End If

 

 

I have tested a record and know the DOB is null.  

 

txtAgeThisDay.Value = "No Dob" is not triggering.

 

Could some one please tell me why?

 

TIA

 

Joe Hecht

jmhecht at earthlink.net

 




More information about the AccessD mailing list