[AccessD] Access #Num! When Calculating A Field

paul.hartland at fsmail.net paul.hartland at fsmail.net
Wed Dec 10 09:39:26 CST 2003


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


More information about the AccessD mailing list