Format numerics inside text control.

I have a numeric variable inside a text control that I want formated as a standard number.  The text control data source looks like this ...  ="as a minimum and "& [VarNum1] & " as a maximum."  I tried formatting the entire control as Standard, 0 decimal places but to no avail.  When the number get over one thousand I want to see commas.  Is there a format command that works "in-line" like an immediate "if" to solve this problem?
jdfullerAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
stevbeConnect With a Mentor Commented:
oops ... 0 decimals
="as a minimum and "& Format([VarNum1], "#,###") & " as a maximum."
0
 
stevbeCommented:
="as a minimum and "& Format([VarNum1], "#,###.00") & " as a maximum."
0
 
jdfullerAuthor Commented:
I have just tried (Format([VarNum1], "Standard")) and got 1,000 !! Great but don't need decimal.  Format([VarNum1], "#,###") works.  Will this treat millions properly? - YES!!  Thanks Steve.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.