Percent

A

awach

I have a form where users enter a percentage of each section. Is there a way
that the user can just enter 34 to show 34% instead of having to enter .34?

I also have a report linked to the data from this form that I would like to
show 34% as well.

Any ideas?
 
T

Tom Lake

awach said:
I have a form where users enter a percentage of each section. Is there a
way
that the user can just enter 34 to show 34% instead of having to enter
.34?

I also have a report linked to the data from this form that I would like
to
show 34% as well.

Any ideas?
Click to expand...

Sure. In your formula to compute percentage, divide the user's entry by
100.

Tom Lake
 
C

Carl Rapson

It seems to me you have two options:

1. Change how you display the value in your form/report. In other words,
change the display formatting to be numeric instead of percent, and place a
label containing the '%' character at the end of the text box displayhing
your percentage.

2. In the BeforeInsert/BeforeUpdate events of the form, check the value
entered by the user and, if it's greater than 1, divide it by 100 to get the
fractional value to store in the table.

HTH,

Carl Rapson
 
Top