Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

For gcs001

Posted on 2000-04-03
5
Medium Priority
?
163 Views
Last Modified: 2010-05-02
From dosyl.
0
Comment
Question by:dosyl
  • 3
  • 2
5 Comments
 
LVL 4

Expert Comment

by:gcs001
ID: 2681037
Hi dosyl,
What's the question?
0
 
LVL 1

Author Comment

by:dosyl
ID: 2681197
It was only to give you some points for the question:
http://experts-exchange.com/Computers/Programming/Windows/Visual_Basic/Q_10321311.html
In passing, is it the best way to convert a String in Currency: cdbl(val(Text1.text)).
0
 
LVL 4

Expert Comment

by:gcs001
ID: 2681531
Thanks dosyl, much appreciated.

You could also look at the Format function - it is more flexible.
0
 
LVL 1

Author Comment

by:dosyl
ID: 2682077
Can you write Cdbl(Val(Text1.Text)) with the format function?
0
 
LVL 4

Accepted Solution

by:
gcs001 earned 100 total points
ID: 2683255
To convert Text1.Text to a Currency value you can try:
Format(Text1.Text), "Currency")

or if you want to first convert it to a Double and then to a Currency try:
Format(CDbl(Val(Text1.Text)), "Currency")

Both should work.

Regards,
Grant.
0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Question has a verified solution.

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

There are many ways to remove duplicate entries in an SQL or Access database. Most make you temporarily insert an ID field, make a temp table and copy data back and forth, and/or are slow. Here is an easy way in VB6 using ADO to remove duplicate row…
Introduction While answering a recent question about filtering a custom class collection, I realized that this could be accomplished with very little code by using the ScriptControl (SC) library.  This article will introduce you to the SC library a…
As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
Get people started with the process of using Access VBA to control Outlook using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Microsoft Outlook. Using automation, an Access applic…
Suggested Courses

972 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