format number

Hi.  I use in txbox of the report following expression: =Format([Weighted_DSC],"#,###.00")

If number is <0, Access displays .90
How can I get Access to display 0.90
maximyshkaAsked:
Who is Participating?
 
Shanmuga SundaramConnect With a Mentor Director of Software EngineeringCommented:
format (number,"#0.00")
0
 
JimFiveConnect With a Mentor Commented:
Use =format([Weighted_DSC],"#,##0.00")
0
 
Shanmuga SundaramDirector of Software EngineeringCommented:
or format (number,'#0.00'). Hope this helps
0
 
Shanmuga SundaramDirector of Software EngineeringCommented:
0
All Courses

From novice to tech pro — start learning today.