I tried a few things, none worked.
But, the values that come in will always be whole numbers, so the numbers that go out will still be whole numbers, even if they have .00 at the end.
Is the value not equal to the integer constant, or is there something else where the decimals are messing up a calculation?
You may have to INT() the value in the comparison(s).
Sorry not more help...
>If I change ControlSource to IncomingCases.AgencyCode (AN INTEGER FIELD), AgencyChoice.Value becomes a numeric value with 2 decimal places.
>
>Can anyone tell me why? or help me make it be an integer?
>
>This has been driving me nuts for a long time now...I've tried to set THis.Value =INT( This.Value ) in various places to get it to be an integer, but cannot get it to stay an integer (I need this, to compare it w/an integer constant).
>
>Please help! TIA, J
Insanity: Doing the same thing over and over and expecting different results.