Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Format Percent

Posted on 2008-06-19
2
Medium Priority
?
886 Views
Last Modified: 2012-08-13
I put an unbound field on the screen into which the user will enter a percent.  The percentage entered can have up to 3 significant digits.  Simple, right?

I put the text box on the screen and set the Format property to 'Percent'.  Initially I had the decimal places set to 3 and later changed it to 'Auto' but the behavior was the same in each case.

The issue is that I can't enter decimals.  it is quite possible that the percentage entered into this field will be something like 1.125 but when I enter 1.125 it shows as 112.50%.  My users are easily confused and I', sure they won't understand this.

I can set the property to 'Fixed' and decimals to 3.  That way when the user enters 1.125 that is what is displayed.  However, I thought it would be a nice touch and make the fiedl more intuitive if I showed the % sign.

Is there a way to set up a field with format 'Percent' such that when 1.125 is entered it shows as 1.125% (without any code manipulations for example: divide by 1000,  behind the scenes)
0
Comment
Question by:mlcktmguy
  • 2
2 Comments
 
LVL 22

Accepted Solution

by:
Kelvin Sparks earned 500 total points
ID: 21827930
Access 2007 has introduced the feature you seek. In the version you have, its either enter the amount & process & display behind the scenes or leave oout the % display and have it just outside the text box as a label.


Kelvin
0
 
LVL 22

Expert Comment

by:Kelvin Sparks
ID: 21827991
Just keep in mind if you store 1.25% as 1.25 and you have to use it in a formula or calculation to divide it by 100.
0

Featured Post

Prepare for your VMware VCP6-DCV exam.

Josh Coen and Jason Langer have prepared the latest edition of VCP study guide. Both authors have been working in the IT field for more than a decade, and both hold VMware certifications. This 163-page guide covers all 10 of the exam blueprint sections.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
Did you know that more than 4 billion data records have been recorded as lost or stolen since 2013? It was a staggering number brought to our attention during last week’s ManageEngine webinar, where attendees received a comprehensive look at the ma…
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…

972 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question