Percent


G

Guest

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?
 
Ad

Advertisements

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?
Sure. In your formula to compute percentage, divide the user's entry by
100.

Tom Lake
 
Ad

Advertisements

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Percent 1
Percent Formula 1
percent format 1
Percent Field 3
Grade and Percent fields. 9
Calculate Percent in Form 2
Convert Single to Percent 4
entering percent in textBox 2

Top