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
Thank you for your help
|
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 |