Solved

Format Number in Answer Box

Posted on 2000-02-20
1
146 Views
Last Modified: 2010-05-02
How do I Format a number in the answer box(txtAnswer.Text) with 3 decimal places, No leading zeros and no commas
0
Comment
Question by:earth2d
1 Comment
 
LVL 14

Accepted Solution

by:
mcrider earned 10 total points
ID: 2540321
Use the Format statement....

For example:

   Dim X
   X = 2.23456
   txtAnswer.Text = Format(X,"#.000")

txtAnswer will contain 2.234


Cheers!
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Sending a email via excel using vba 6 97
vbModal 12 57
Problem to line 23 54
transition to visual .net from vb6 5 41
I’ve seen a number of people looking for examples of how to access web services from VB6.  I’ve been using a test harness I built in VB6 (using many resources I found online) that I use for small projects to work out how to communicate with web serv…
Article by: Martin
Here are a few simple, working, games that you can use as-is or as the basis for your own games. Tic-Tac-Toe This is one of the simplest of all games.   The game allows for a choice of who goes first and keeps track of the number of wins for…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
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…

829 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