Percent problem again

[TomH]

Percent problem again
Hi
I have a form with a percent field. Percent is number and double in the table.
To show the actual percent, I put this code in the event AfterUpdate:
Percent.Value = Percent.Value / 100
This is working when I write new numbers in the field, but when I put the
cursor in the field and edit an existing percent the result is wrong.
Exampel: edit 4 to 5 in 34% ends up with 0,35% when enter.

This little problem drives me crazy. Is there anyone please, who have a
solution?

 

[SusanV]

Instead of changing the data, change the Format property of the field to
Percent in the table.

 

[TomH]

Hi, I have this question under the Database design, so take a look there.