View Full Version : Change percent properties


Cdogg
12-29-2001, 04:06 AM
Can I change the way the percent appears in a textbox from 100.00% to 100%

Thank you for your help

Cdogg
12-29-2001, 04:46 AM
Can I change the way the percent appears in a textbox from 100.00% to 100% With out having to enter it as .5 for 50%

Thank you for your help

Rich
12-29-2001, 05:20 AM
Set the decimal places to 0, and this article shows how to do the second question.
Article ID: Q142228

David R
01-02-2002, 02:59 PM
Rich, that article doesn't exist any longer.

Rich
01-02-2002, 03:46 PM
Here's the relevant part.
Text Box:
Name: Field1
AfterUpdate: [Event Procedure]
Text Box:
Name: Discount
ControlSource: Discount

4. Set the Field1 field's AfterUpdate property to the following [Event
Procedure]:

Sub Field1_AfterUpdate()
Me!discount = Me!field1 /100
Me!field1= Format(Me!field1 /100, "###.00%")
End Sub

5. Set the form's OnCurrent property to the following [Event Procedure]:

Sub Form_Current(Cancel as Integer)
Me!field1 = Format(Me!discount, "###.00%")
End Sub

HTH