Formatting currency to show cent symbol

L

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

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.
 
Top