value entryfield changes

  • Thread starter Jean-Paul De Winter
  • Start date
J

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
 
R

Rick Brandt

Jean-Paul De Winter said:
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
Click to expand...

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.
 
Top