Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 569
  • Last Modified:

Creating a mask for a percentage

I am trying to create a mask in order to show a percentage.  I've tried "99.99%" and variations, but nothing works.  

I have a textbox that is displaying a float from a database.  I don't want it to show 25.1, but 25.1%.  I know I can go in and adjust the textbox.text, but I'd rather just have a mask.  I will having a lot more of these down the road.  
0
vlvawter
Asked:
vlvawter
  • 4
2 Solutions
 
Leo EikelmanDirector, IT and Business DevelopmentCommented:
hmm try either one of these

LblPctTotal = Format(lblPctTotal, ?Percent?)


or any of these ways of calling FormatPercent

lblTotalPct = FormatPercent(NumToFormatAsPercent)

lblSumPct = FormatPercent(NumToFormatAsPercent, NumOfPlaces)

lblCurrInterest = FormatPercent(CurrentInterest)
0
 
Leo EikelmanDirector, IT and Business DevelopmentCommented:
if u wanted to actually mask it look at this

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vbcon98/html/vbconusingmaskededitcontrol.asp


You would use the .Mask property and specify 0% for percentages


Cheers,

Leo
0
 
Leo EikelmanDirector, IT and Business DevelopmentCommented:
I think in my first post I made a typo

this line

LblPctTotal = Format(lblPctTotal, ?Percent?)

should read

LblPctTotal = Format(lblPctTotal, "Percent")


Cheers,

Leo
0
 
g_johnsonCommented:


Const strFormat = "#0.0#%"

debug.print format(.251,strformat)
0
 
Leo EikelmanDirector, IT and Business DevelopmentCommented:
Both mine and g_johnson's techniques will work, split points.

Leo
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

  • 4
Tackle projects and never again get stuck behind a technical roadblock.
Join Now