Format field as percent

  • Thread starter Thread starter Dianne
  • Start date Start date
D

Dianne

Is there any way to format a number field as percent so
that you do not have to enter the number as .03 to obtain
a value of 3%. I want to type in just the number 3 and
have it appear as 3%
 
Is there any way to format a number field as percent so
that you do not have to enter the number as .03 to obtain
a value of 3%. I want to type in just the number 3 and
have it appear as 3%
Click to expand...

Simplest solution is just to store the 3 and remember to divide by 100 when
you do the maths later. Therefore, if the query used to be

SELECT FinalCost * (1 + TaxPerCent) AS NetCost
FROM etc...


you just change it to

SELECT FinalCost * (100 + TaxPercent) / 100 AS NetCost
FROM etc...

If you want to provide a visual clue to the user, try putting a label
containing the "%" character just to the right of the text box on the form.

Hope that helps

Tim F
 
Back
Top