showing percentages

[kpryan]

Hi,

I have to design a form with several number text boxes formatted with the %. I need to be able to enter a figure in % eg:9% and to use to calulate other fields in currency.

On the lostfocus event I use this code;
Field = nz([field])*.01 (to get the correct%)

However if you use the cursor in the textbox and lose focus again, it changes the original input.eg 9% to 009%
How do I correct this problem

Thanks,

Ken

 

[Remou]

Hi
It may be better to use the After Update event. Then the update will occur if the user changes the data.