Solved

Format numerics inside text control.

Posted on 2006-11-29
3
192 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

Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

Question has a verified solution.

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

When you are entering numbers in a speadsheet, and don't remember what 6×7 is, you just type “=6*7" instead. It works in every cell! This is not so in Access. To enter the elusive 42 in a text box, you have to find a calculator, and then copy the re…
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…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…

911 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

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now