#Num! ???

  • Thread starter Thread starter evilcowstare via AccessMonster.com
  • Start date Start date
E

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 !
 
In
evilcowstare via AccessMonster.com said:
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 !
Click to expand...

You might try this controlsource expression:

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