Testing for zero 1

[leej1]

Hi
This should be very easy, but I can't seem to solve the problem.
I have a form with controls from a table defined as Currency (2) dec., which I perform a function to get an answer for a control from a table also defined as Currency (2) dec.
I test the answer for zero. The control on the form and in the table appears as $0.00, but the real value is .0045 for example, which won't meet the condition of zero.
Thanks leej1

 

[ZmrAbdulla]

You may try changing the format of the currency field to Fixed/Standard. It might be set to general number

________________________________________________________________________
Zameer Abdulla
Visit Me
Children are poor men's riches.

 

[TheAceMan1]

How are ya leej1 . . . . .

[blue]   If Int(100 * Me!TextboxName) = 0 then
      'Do this [purple]if true[/purple]
   Else
      'Do this [purple]if false[/purple]
   End If[/blue]

Note: the value [blue].0045[/blue] is truely not zero! Is it your intent to stripout values beyond the 2nd decimal place?

If so, be aware [blue]your cutting down the accuracy of calculations.[/blue]

See Ya! . . . . . .