#Num! ???

[evilcowstare via AccessMonster.com]

Hi I have a txt box called GP which for its control source is doing a
calculation of....


netvalue/margin

It works fine when there is stuff in the boxes for netvalue and margin but
when the boxes are on their default of £0.00 it says #Num! in the txt box for
GP, is there anyway i can make the txt box blank until stuff is entered or
how to get rid of the display #Num!

Thank You !

 

[Dirk Goldgar]

In

Hi I have a txt box called GP which for its control source is doing a
calculation of....


netvalue/margin

It works fine when there is stuff in the boxes for netvalue and
margin but when the boxes are on their default of £0.00 it says #Num!
in the txt box for GP, is there anyway i can make the txt box blank
until stuff is entered or how to get rid of the display #Num!

Thank You !

You might try this controlsource expression:

=IIf(margin = 0, 0, netvalue/margin)