[AccessD] A little Null Help Please

Joe
Try this 

If isnull(DOB) then 
	txtAgeThisDay.Value = "No Dob"
Else
	txtAgeThisDay = yearcalc(DOB, txTaCCIDENT_dATE) 'Calc Age on Event
Day
End If

HTH

Vinnie Chas
www.vinniechas.com

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Joe Hecht
Sent: Saturday, February 11, 2006 8:52 PM
To: 'Access Developers discussion and problem solving'
Subject: [AccessD] A little Null Help Please

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

 

--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com


-- 
No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.1.375 / Virus Database: 267.15.6/257 - Release Date: 2/10/2006