Printing the minus sign after the number.

[Guest]

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,

 

[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
(e-mail address removed)

 

[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,

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

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

 

[StopThisAdvertising]

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
(e-mail address removed)

--
You are *not* a resource at all !!
Stop advertising here, or get lost for another year or so...
http://home.tiscali.nl/arracom/whoissteve.html

ArnoR