Solved

Format Percent

Posted on 2008-06-19
2
869 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
2 Comments
 
LVL 22

Accepted Solution

by:
Kelvin Sparks earned 125 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

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

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…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…

739 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