Printing the minus sign after the number.

J

John Melbourne

Hi All,
Maybe I just don't know what I'm doing but I need to format my
negative number with the minus sign to the right of the number instead off
the left in my reports.
Any help appreciated.
Regards,
 
S

Steve

Assuming the number field in the recordsource is MyNumber, include a hidden
textbox named HideMyNumber bound to MyNumber.

Put the following in the control source property of an unbound textbox:
=IIF([HideMyNumber]<0,Abs([HideMyNumber]) & "-",[HideMyNumber])

PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
[email protected]
 
F

fredg

Hi All,
Maybe I just don't know what I'm doing but I need to format my
negative number with the minus sign to the right of the number instead off
the left in my reports.
Any help appreciated.
Regards,
Click to expand...

Set the Format property of the control to:
#;#-;0

See Format Property + Number and Currency datatype
in Access help.
 
Top