Change percent properties

[Cdogg]

Can I change the way the percent appears in a textbox from 100.00% to 100%

Thank you for your help

 

[Cdogg]

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]

Set the decimal places to 0, and this article shows how to do the second question.
Article ID: Q142228

 

[David R]

Rich, that article doesn't exist any longer.

 

[Rich]

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