How to set a form field to display percentage number entry as "50%" or "50.50%" automatically. If The decimal is zero (0), then display as 50% and if the decimal is 50.50 then display as 50.50%. Thanks in advance for help. Gopans
Novice
Windows 10 
Access 2013 64bit
How to set a form field to display percentage number entry as "50%" or "50.50%" automatically. If The decimal is zero (0), then display as 50% and if the decimal is 50.50 then display as 50.50%. Thanks in advance for help. Gopans
Competent Performer
Windows 10 Access 2013 32bit
Neither process makes sense. Please describe why displaying 50% when the value is 0 and 50.50% when the value is 50.50 is valid.
VIP
Windows 7 64bit Access 2010 32bit
Why don't you display as 50.0% and 50.5%? Why different number of decimal places?
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
Novice
Windows 10 Access 2013 64bit
jwhite.. does it look good to see 50.00% in a report?.. does 50% looks good?
VIP
Windows 7 64bit Access 2010 32bit
Looks better to have all values show the same number of decimal places, all aligned on the decimal point. Easier to read.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
How to calculate percentage of one field's value to another?
Posting Permissions
Reply With Quote