Solved

For gcs001

Posted on 2000-04-03
5
146 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 50 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

Networking for the Cloud Era

Join Microsoft and Riverbed for a discussion and demonstration of enhancements to SteelConnect:
-One-click orchestration and cloud connectivity in Azure environments
-Tight integration of SD-WAN and WAN optimization capabilities
-Scalability and resiliency equal to a data center

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Validating VB6 Function 19 65
How does CurrentUser work? 10 38
VB 6 error 5 in windows 10 but not in XP 7 63
RUNRMTCMD from AS/400 12 68
Most everyone who has done any programming in VB6 knows that you can do something in code like Debug.Print MyVar and that when the program runs from the IDE, the value of MyVar will be displayed in the Immediate Window. Less well known is Debug.Asse…
When designing a form there are several BorderStyles to choose from, all of which can be classified as either 'Fixed' or 'Sizable' and I'd guess that 'Fixed Single' or one of the other fixed types is the most popular choice. I assume it's the most p…
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…
Get people started with the process of using Access VBA to control Excel using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Excel. Using automation, an Access application can laun…

789 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