Formatting currency to show cent symbol "L.A. Lawyer" <kapplaw[ at ]linkline.com> 12/19/2008 2:14:34 AM I have to refer to a series of currency amounts (less than $1 each). I can easily format them to show "$0.45"; is there any way to show that as 45 cents (using the cents symbol)?

Re: Formatting currency to show cent symbol "Linq Adams via AccessMonster.com" <u28780[ at ]uwe> 12/19/2008 4:00:26 AM The exyended ASCII for the cent symbol is 162, so entering in a textbox Private Sub txtSmallChange_AfterUpdate() Me.txtSmallChange = Me.txtSmallChange & Chr(162) End Sub Similar code could be used in other ways. -- There's ALWAYS more than one way to skin a cat! Answers/posts based on Access 2000/2003 Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/Forums.aspx/access-formscoding/200812/1