Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

Format numerics inside text control.

Posted on 2006-11-29
3
195 Views
Last Modified: 2006-11-29
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?
0
Comment
Question by:jdfuller
  • 2
3 Comments
 
LVL 39

Expert Comment

by:stevbe
ID: 18039932
="as a minimum and "& Format([VarNum1], "#,###.00") & " as a maximum."
0
 
LVL 39

Accepted Solution

by:
stevbe earned 125 total points
ID: 18039942
oops ... 0 decimals
="as a minimum and "& Format([VarNum1], "#,###") & " as a maximum."
0
 

Author Comment

by:jdfuller
ID: 18040004
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

Featured Post

The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Overview: This article:       (a) explains one principle method to cross-reference invoice items in Quickbooks®       (b) explores the reasons one might need to cross-reference invoice items       (c) provides a sample process for creating a M…
As tax season makes its return, so does the increase in cyber crime and tax refund phishing that comes with it
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…

840 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question