Printing the minus sign after the number.

  • Thread starter Thread starter Guest
  • Start date Start date
G

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,
 
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)
 
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.
 
Steve said:
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)
Click to expand...

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