K Kaylen Jan 26, 2009 #21 The code works! Thank you Clifford! Clifford Bass said: Hi Kaylen, Try this instead: If Not IsNull(controlname) And Right(controlname, 1) <> "%" Then controlname = controlname / 100 End If Clifford Bass Click to expand...
The code works! Thank you Clifford! Clifford Bass said: Hi Kaylen, Try this instead: If Not IsNull(controlname) And Right(controlname, 1) <> "%" Then controlname = controlname / 100 End If Clifford Bass Click to expand...
J John W. Vinson Jan 26, 2009 #22 With Access 2007 I believe all you have to do is set the control's Format property to Percent. Click to expand... That is what I had not realized. That certainly makes it simpler than my suggestion!
With Access 2007 I believe all you have to do is set the control's Format property to Percent. Click to expand... That is what I had not realized. That certainly makes it simpler than my suggestion!
K Kaylen Jan 26, 2009 #23 Thank you for everyone' s help and suggestions. I am able to format the number to Percent the way I would like to! Thank you all for being so helpful!
Thank you for everyone' s help and suggestions. I am able to format the number to Percent the way I would like to! Thank you all for being so helpful!
