Percent problem again

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Percent problem again
Hi
I have a form with a percent field. Percent is number and doublein the table.
To show the actual percent, I put this code in the event AfterUpdate:
Prosent.Value = Prosent.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?
 
Either ditch the code entirely and enter your percents as .35 or check the
value before /100.

Me!Prosent.Value = Me!Prosent.Value / IIf(Me!Prosent.Value<1,1,100)
 
My point is that I want to write the percent in the field as you read it.
(35% is to be written as 35%, not 0.35).

Tried your code, but it didnt worked as I hoped.


Thank you for trying.
 
"didnt worked as I hoped" doesn't give us much to go on since we don't know
your exact code and your results.

If you want additional help, you have to provide more information.
 
My point is that I want to write the percent in the field as you read
it. (35% is to be written as 35%, not 0.35).
Click to expand...

In that case store it that way! Use an integer (for example, unlesss you
want stuff like 17.5%) in the range 0 to 100. A good clue for your users is
to place a label to the right of the textbox on the form with a "%"
character in it.

When you use the number in your calculations, you put in the factor of 100
then:

TruePrice:= BasePrice * (1 + TaxPerCent/100)

and so on.

B Wishes


Tim F
 
I'll try too explain my problem better:
- When i write a new percentage, e.g. 65.7, the result after enter is 6570
(this is well known). I correct this whit the formula in the event
afterupdate (dividing by 100) so the result end up as 65.7. So far so good.
- But if I edit the 65.7, lets say I shade the 5-digit and write 2 so the
percentage is 62.7 before enter, the result after enter is 0.627.

This mean the field act in two ways after enter, one when writing a new
percentage and one when editing a existing percentage.

What i ned is a code or formula who do this:
IIF(editing a existing percentage; do nothing; ELSE, divide by 100)
Is there any VBA code who identify wheter you write a new numer in a field
or edit it? If so, my problem is solved, if not, i got a unsolvable problem.

Hope this gave more information.
 
I tested my code and it works exactly as you asked. I entered 65.7 and it
converted to 65.70%. I then changed the 5 to a 2 and the result was 62.70%.

I mentioned "we don't know your exact code" which you seemed to have
ignored. I can't determine why your implementation didn't work while mine
did.
 
Yes sir, youre right, it worked as you said.
I hanged up in the borderline case whom is less than 1. You now, e.g. 0.65
of a million, the users wont be happy when they notice 65%.

I must problably realize it is not possible to make a general code or
formula that handle all cases of the percentage problem.

Thanks anyway for yor help and patience with me.

Regards
 
Back
Top