I have 2 fields on my form that perform a add and a multiply. I tried the below code to make them show a zero value, no luck.
SetValue [Text480] = Nz([Text480], "0") ' tried this code to make it be a zero value if is null
=[Disc#]*[SumTotal1] 'multiplies discount by total and it gives me a #error in the field.
=(Nz([Text480],0)) ' Default Value. Tried to make it show zero if no value
Text478 a textbox uses this control source =Sum(Nz([DiscRate],0)*Nz([SumTotal1],0))
Text480 a textbox uses this control source =Nz([DiscRate]*[SumTotal1],0) ' Both show a #error in the fileds