value entryfield changes

[Jean-Paul De Winter]

Hi,
I have this entryfield that contains a value with 2 decimals.
The notation is "Euro"
When the form is opened the value of this entryfield is calculated.
When I move the cursor into the entryfield and click, I get a number
with 4 or even more decimals...
How can this be avoided?
Thanks
JP

 

[Rick Brandt]

Hi,
I have this entryfield that contains a value with 2 decimals.
The notation is "Euro"
When the form is opened the value of this entryfield is calculated.
When I move the cursor into the entryfield and click, I get a number
with 4 or even more decimals...
How can this be avoided?
Thanks
JP

As you have seen formatting only affects dispaly, not what is actually in the
field/control. When you place the cirsor there you are then shown the real
value.

You need to have your calculation actually round to two decimal places and then
this won't happen. Newer versions have a Round() function for this. In older
versions you can use the Format() function.