Formatting currency to show cent symbol

[L.A. Lawyer]

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)?

 

[Linq Adams via AccessMonster.com]

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.