Percent

G

Guest

I have a field called TAX. How should I setup the field
so when the user enters 6.5 the result will be 6.5%.
Currently I have the field set at long integer and format
as percent. When I enter 6.5 I get 650.00%.

Any help would be appreciated...

Rick
 
K

Kailash Kalyani

A quick and easy way is to add the following code to the after_update event
of your textbox

mytxtbox.value = mytextbox.value/100

hope that helps.
 

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 Field 1
Calculated tax percent keeps repeating same tax in each record. 1
Another simple formula?? 20
Condtional Formatting 2
Access Test if value is less than percent 0
Grade and Percent fields. 9
Format a Percent 4
2007 Percent field Issues 8

Top