[AccessD] Access #Num! When Calculating A Field

Set your unbound textbox Control Source to the following:

=iif([txtNoOfCases] > 0, [txtNoOfErrors]/[txtNoOfCases], 0)

Doris Manning
Database Administrator
Hargrove Inc.
www.hargroveinc.com


-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of
paul.hartland at fsmail.net
Sent: Wednesday, December 10, 2003 10:39 AM
To: accessd
Subject: [AccessD] Access #Num! When Calculating A Field


To all,
 
I have two bound fields on a form (txtNoOfCases & txtNoOfErrors), I then
have an unbound textbox set to Percent with the control source being 
 
=[txtNoOfErrors]/[txtNoOfCases]
 
But when you first open the form the unbound textbox has #Num! in it until
you enter a value in either of the two fields.  How can I make the unbound
textbox say 0.00 instead of #Num! until data is entered ?
 
Thanks in advance for you help.
 
Paul Hartland
Freeserve AnyTime - HALF PRICE for the first 3 months - Save £7.50 a month 
www.freeserve.com/anytime _______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com