change the way percentages apprear

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

esparzaone - 19 May 2005 19:19 GMT

When I enter percentages it shows like this
I enter 4
it appears 400.00%
I want it to show 4% or even 4.00%

I know this seems simplistic but I an having a difficult time with this!
Thanks

Reply to this Message

Duane Hookom - 20 May 2005 01:11 GMT

You should enter .04 for 4 percent since all whole numbers greater than 1
are greater than 100%.

An alternative is use the after update event of the text box to check the
value to see if a higher number is entered and divide the number by 100.

Private Sub txtMyPct_AfterUpdate()
If Me.txtMyPct > 1 Then
Me.txtMyPct = Me.txtMyPct / 100
End If
End Sub

Signature

Duane Hookom
MS Access MVP
--

> When I enter percentages it shows like this
> I enter 4
[quoted text clipped - 3 lines]
> I know this seems simplistic but I an having a difficult time with this!
> Thanks

Reply to this Message