Hi, I have declared Vat as type Currency, and I am calculating Vat as 15% of an amount. Is there any function ar any way that I can round the Vat figure to 2 decimal places?Thanks for any helpZ
View Complete Forum Thread with Replies
See Related Forum Messages: Follow the Links Below to View Complete Thread
Format Currency To Indian Format In Label/Textbox
I am trying format the currency data in DB (Acs 2003) into Indian currency format 00,00,00,000 for which I used the below code
Me.lblAmt.Caption = Format(CCur(rsCurrent.Fields("suitAmount")), "##,##,##,##,##,##0")
but during display nothing happens i.e. the display continues to be the US format.
Can somebody show me how.
Thanks in advance.
Currency Format Help Please
Please can someone help, I use the code below to enter numbers into a textbox, but i need the numbers in the textbox to be in a currency
Private Sub cmdNum_Click(index As Integer)
Select Case cmdNum(index).Caption
Case "0" To "9"
txtTender.Text = Format(cmdNum(index).Caption, "Currency")
If cmdNum(index).Caption = "." Then
I have added the curency bit in but it only works for the first number pushed say for example if you push 65 the textbox displays $6,00 indtead of $65,00.
Please can someone tell me what i am doing wrong.
I have created a program with multiple check boxes. Each time a check box is selected I want it to add a currency amount of .50 to the second text box and then add the amount in the first text box to that of the second and populate the total in the third text box. The first time a check box is selected it is accurately showing the amount in the second box as a currency of $0.50 but does not total the amount into the third box. The second time a check box is selected it goes to .5 but this time it does total the third box. As subsequent check boxes are selected it is adding the numbers up accurately...but no longer showing them as currency. Please view the code below and let me know if you can see what I'm doing wrong.
Private Sub chkToppings_Click(Index As Integer)
If txtToppings.Text = "0.00" Then
txtToppings.Text = FormatCurrency(0.5, 2)
Else: txtToppings.Text = Val(txtToppings.Text) + FormatCurrency(0.5, 2)
txtTotal.Text = Val(txtPizza.Text) + Val(txtToppings.Text)
This what I tried but its not working
Private Sub txtCurFields_Click(Index As Integer)
Select Case txtCurFields(Index)
txtCurFields(0) = FormatCurrency(txtCurFields(0).Text)
txtCurFields(1) = FormatCurrency(txtCurFields(1).Text)
txtCurFields(2) = FormatCurrency(txtCurFields(2).Text)
The array has many more textboxes ofcourse but this is what I am using to test it.
I want all of the fileds to format for currency
Oh and where should this be.. in the click or change or else where
How do I set the Currency format to
instead of 3000
I want a comma after 3 digits. If u know of a way to set it, please let me know. Thanks
Format As Currency
Here is my code:
i am storing a number into a variable, and then i want to make that number come out as currency. However, i get an error saying that a = is required after the end parenthesis. I would guess that i cant format the value this way becuase it is in a variable (opposed to just putting in "########"). If thats the case i have no idea how to get it to work.
Format Currency.. Help
How do I make the outputs in the Captions for the Labels come out as Currency? Like $5.00 for example..
I tried adding FormatCurrency in front of the label name, but it did not work.
Private Sub cmdCalc_Click() Const BurgerP As Currency = 1.25 Const FriesP As Currency = 1 Const DrinkP As Currency = 0.75 Const Tax As Currency = 0.08 Dim intBurgerQ As Integer Dim intFriesQ As Integer Dim intDrinkQ As Integer Dim curTotalF As Currency Dim curTax As Currency intBurgerQ = Val(txtBurgerQuantity.Text) intFriesQ = Val(txtFriesQuantity.Text) intDrinkQ = Val(txtDrinkQuantity.Text) lblTotBurger.Caption = intBurgerQ * BurgerP lblTotFries.Caption = intFriesQ * FriesP lblTotDrink.Caption = intDrinkQ * DrinkP curTotalF = Val(lblTotBurger.Caption) + Val(lblTotFries.Caption) _ + Val(lblTotDrink.Caption) + Val(lblDeliveryCharge.Caption) lblSubTotalDisplay.Caption = curTotalF curTax = Val(curTotalF) * Tax lblTaxDisplay.Caption = curTax lblTotalDisplay.Caption = curTotalF + curTax End Sub
The user enter "1023.2" into a textbox. I want to use printer.print to get "$1023.20". How do I format so both the dollar sign and the zero is shown on the printout?
Format Decimal, Currency Like...
Frustrating, Looking for some serious fast help from anyone, thanks for any replys of help. My problem might be easier than I can see... What I have is a textbox with $0.00 and I want to be able to click any of the buttons, 1-0. When I click 1 for the first time I want the textbox to = $0.01, If I click button 1 again, next to = $0.11 and so on = $1.11 -> $11.11 -> $111.11, so I need to keep a format I guess, but I can't seem to get the format code to work. I been working with this for several hours, I didn't ask for help because I believed I could figure it out myself but seem to be stupidified. I know how to make the string continue... example textbox = textbox & "1" but next I need the format = "$0.00" Appreciate any help from people. Thanks
Format A Label As Currency
I am trying to format a label as currency. The data is from a datasource and is formatted in the database as currency, but when the data shows on the form it is not formatted. How can I format this data to appear as currency when the form is printed or viewed at runtime?
What Is The Format For Indian Currency?
What is the format for Indian Currency?
Say, for US format for currency : 200,000.00
and Indian currency format is like this : 2,00,000.00
txtCash.Text=Format, " ???? "
So, what is the format to be written for a txtbox?
Currency Format In Different Region
how to get the currency format?
i mean in indonesian it's like this ex: 1.234.567,00
in US ex: 1,234,567.00
not sure in other countries
since i making a ConvertToText program but it fail when it met US region
if i code the possibilities then it wouldn't make sense since what if somewhere the format might like 1#234#567*00
hope u know what i mean
Format Number As Currency
Alright now; this problem has been seriously bothering me.
I'm attempting to make something that displays an amount of money for every hour/minute/second worked.
It works, but the number I get has an obscene amount of numbers after the decimal point.
How do I format the number like a currencey?(USD)
so, that it's like #####.## with only two numbers after the decimal point?
Thanks in advance.
RESOLVED Currency Format
I have a label on a form which is calculated from values in other text boxes, and im trying to format the total label into the currency format, but all its ends up printing in the label is "lblTotal.Caption" and not formatting the number
lblTotal.Caption = txtOne.Text + txtTwo.Text Format("lblTotal.Caption", "Currency")
what am i doing wrong?
Format Text Into Currency
What I want to do is format my text into $999, 999.99
I use format("txtbox.text", "Currency") which works when the values is less than $9999.99, but when I want a number say like 123456.78, it will give me $123456, w/ no decimals. I wanna be able to enter in dollars amounts less than a million and be able to format it like $999, 999.99
How is this done?
How Format A Textbox For Currency
How to format a textbox for currency without using Maskedit Box. The only way at the moment is read the textbox and write back to the textbox with format function in the coding. This somehow creates some complication in the multiuser environment because the data is bound to a table.
Because it writes back to the textbox with the currency format "#,###,##0.00" it's actually changing the field.
Is it possible using API? Or is there any possible way where the format can be set and without have to use Maskedit or Richtextbox.
Thanking in advance
Currency Format And Validation
my application needs to allow user enter different currency, and I want to validate that currency code is a valid one, and format it as well.
if the user enters 100 and if the windows setting is USD, then it needs to display 100.00USD. if the user enters 100NZD, then I need to validate if NZD is a valid currency code, if it is, display it as 100.00NZD.
I looked at the format, FormatCurrency. but both seem to only use the windows setting for the currency. is there any built in function that parses a string, validates currency code, and reformat the string into currency format?
Currency Format In Bound Textbox
Can someone help me out, I'm new to VB? I'm trying to currency format a db bound textbox. When I use "txtFields(3) = Format(txtFields(3).text, "Currency")" on a change event, I can't modify my data properly because it's triggered on the first keystroke.
I'm running vb5 and can't find any help on MS.
Thanks Thinker, the lostfocus event is good but formating does not appear on the form_load event. How can I trigger it to load with formats?
How Do You Convert Values Into Currency Format
i am using visual basic 6.0 and on one of my forms i need to do a calculation that calculates the difference between incomings and expenses-i have figured out this code and the code works fine
Heres the problem, at the moment in the textbox the user can enter anything, i want it so that the user can just enter numbers-and the textbox format will be currency-i dont know how this works-maybe when the user enters for example 100 this will automatically convert into (when the user goes to next textbox) £100.00-if there is a code for this please post below cuz i am really stuck-
here is the code i have at the moment
Private Sub cmdCalculate_Click()
txtProfit.Text = Val(txtIncomings.Text) - Val(txtOutgoings.Text)
If Val(txtProfit.Text) > 0 Then
txtProfit.ForeColor = vbGreen
txtProfit.ForeColor = vbRed
If Val(txtIncomings.Text) > Val(txtOutgoings.Text) Then
lblResult.Caption = "You made a profit!"
lblResult.Caption = "You made a loss!"
Currency Display Format For A MaskEdBox
I have a MaskEdBox input field and i want to set it up so that only numbers can be enetered in the input box. No decimals or letters.
I think i need it in the key down action i think.....
Currency Format In Text Box (RESOLVED)
I have this very simple question! How can I change the type of a text box to currency. E.t.c. I would like it to display a dollar or Euro sign after the amount is typed!
thx, in advance
MSHFlexGrid Format A Column As Currency
I am just starting to use the MSHFlexGrid I'm used to the standard DataGrid so it was no problem formatting columns as currency so they showed as an example $4500.00. I'm trying to do the same with the MSHFlexGrid but it shows just 4500 not $4500.00. The db is Access and those fields are set to currency and the default is $0.00 in the db anyone know how to fix it??
Sorry I'm just stupid when it comes to the MSHFlexGrid.
Format Currency With Digit Decimal
is there a format express or a way in visual basic 6.0 to format a value i.e. 100 = 100.00. no matter, what I try it always give me 100 and I want i to show as 100.00.
Format Cell To Currency - Error '1004'
I'm trying to format a cell to currency once I've dropped the data on a sheet, but I get the following message: -
Run-time error '1004':
Unable to set the NumberFormat property of the Range class
This is the code I'm using: -
Cells(lngPosY, 4).NumberFormat = "Currency"
If I format it to a number i.e. '#,##0.00' it's fine.
Why is this error happening?
How To Format A Column In Data Grid As A Currency?
Hi, i have datagrid.
I want to format one of the column as a currnecy. Is it possible?
This is what i've done..but there's syntax error. Any idea?
Code:datagrid1.Columns(2).DataFormat = currency
Format Currency Padded W/ Leading Blanks
I am trying to write a currency amount to at RichTextBox and format it like this:
My Input Data is the string: "00278144+"
I want it to display like this: "$__2,781.44" (where the underscores are actually blanks/spaces)
I've tried Format("00278144+", "$###,##0.00), but that doesn't seem to work.
Crystal Reports - Change Currency Format
I've designed some reports that will be used in different areas (Ireland & UK), so my VB app needs to be able to change the report currency format at run time.
I assume you're able to do this using the Crystal Automation Engine, does anyone know of any source for this - must be something that people do quite regularly!
Any links/code appreciated
Need To Make My Labels Appear In A Currency Format And Display $ Sign So $0.00
What i need to do is that when i press add, i want the label to just display it in a currency format e.g. $0.00.
Ohk thats the code for my entire project, I think you should only need to read the code in cmdAdd.
Also I attached my project. If you see it you'll see a dollar sign but thats just a separate label with it in $, kinda cheap i know.
TextBox Wanting To Make Input Text In Currency Format
Ok I am wanting to make the text typed into the textbox to be in currency format.
What I am wanting specifcally is when the user inputs text like; 30,000 or 30000 to automatically change it to $30,000.00
So if they were to type 1 it would be $1.00 or 100 $100.00 ect ect ect
Can this be done?
Convert Currency To Words (Indian Format) In Crystal Reports
Please can anyone help me how to convert number to words in Indian format in Crystal Reports.
eg. I want to convert Rs.25,12,000 as Rupees Twenty Five Lakhs Twelve thousand only.
The towords function converts into millions and billions and i want the result in Lakhs and crores.
Thanks in advance.
Insert Currency Data Type To MS Access Currency Field
Im want to insert a into a currency field in ms access using vb 6.0 but i keep gettin an error message. What should i place around the value to denote insert it.
here is my code:
Dim sqlstmt As String sqlstmt = "INSERT INTO tbl_Products (ProductName,ProductDesc,SalesPrice,SpecialOffer,SpecialOfferPrice) VALUES (" & _ "'" & p_prodName & "', " & _ "'" & p_prodDesc & "', " & _ "'" & p_sPrice & "', " & _ "'" & p_specialOffer & "', " & _ "'" & p_soPrice & "' " & _ ")" MsgBox sqlstmt db.Execute (sqlstmt)
Format (whatever,"Currency") Problem On Some Machines
I'm a little confused, I have a word document with vba code. part of the code uses the format(whatever,"Currency") command, and works fine on 97, 2000, 2002, 2003, But on some computers it is not working. I get an error, and it comes up in the references saying that the windows common controls are missing on these same computers when I check...???? Am I missing something? Have reinstalled word (complete install), but still no joy. It would appear to have something to do with the comctl32.ocx, but I'm not even sure that's right. We have even reinstalled the ocx, but that didn't help.
It's past 1:30 in the morning here, so I won't be replying, but I would love to find suggestions or answers here tomorrow morning!!!
Thanx all in advance.
Format$(xoxo, "currency") Question
I am trying to get a running total of some items entered, and it works just fine when i am not using the Format$, but when I try to convert it to a running total the output is always zero.
Private Sub Command1_Click()
If Check1.Value = 1 Then discount = ((Val(Text1.Text) * (Val(Text2.Text) / 100 + 1)) * 0.1) 'calculating the discount with tax included.
If Check1.Value = 0 Then discount = 0
'stating no discount if box is unchecked
Label5.Caption = Format$(Val(Text1.Text) * (Val(Text2.Text) / 100 + 1) - discount, "currency")
'if i remove the format$ here, and in the next line I will get a running total in label7.caption. however with format$ involved it always returns $00.00
Label7.Caption = Format$(Val(Label7.Caption) + Val(Label5.Caption), "currency")
Format(, "Currency") Does Not Work
i have this code in my program
lblAnswer.Caption = Format(sngAmount, "Currency")
when i run it i get this error:
can't find project or library
am i missing a reference or something? if so what?
New To Using Format$(xxxxxxx."currency")
I have had no success using the format function as follows (the two
lines of code run one after the other):
'displays a running total of lblAmtdue.Caption
'contents in txtTotal.Text
txtTotal.Text = lblAmtdue.Caption + Val(txtTotal.Text)
'tries to format contents of txtTotal.Text as currency; doesn't work
txtTotal.Text = Format$(txtTotal.Text, "Currency")
Of what obvious formatting error am I guilty?
Numeric Currency Value To Word Currency Value
Guys I want to know how we can change Numeric Value of currency to the Word value.
for Ex. If we enter value in textbox “210” after clicking a button change, it will display in the label that “Two Hundred ten only” in label.
I want at least for up to 5 digit.
So I want this type of program for VB Give me whole coding for that Or attach the whole created project that u have done plz help me.
By the way, Happy DIWALI & new YEAR , It is Indian Festival.
Format$(NUMBER, "#.##") Vs Format$(NUMBER, "0.00") Vs Format$(NUMBER, "Currency")
I'm just learning VB and can't seem to find out what the differences are between the three formatting options 0.00, #.##, Currency.
format$(94.445, "#.##") vs format$(94.445, "0.00") vs format$(94.45, "Currency")
I ran small program and formatted 94.445 using all three types, they all returned 94.45. I don't see a differance between 0.00, and #.##. The only noticeable differance was with currency when formatted to a text box showed the dollar sign. Can someone explain the differances? TIA
i have a variable as currency but if i place the value 5.00 into it it always comes out as 5 without the .00
is there a way of keeping the two decimals?
can anyone tell me how to do this.
I need to add and multiply currency with an integer and yeild a dollar ammount. ($12.50)
Right now it will give me this- $12.5 or if it is a whole # I get this $12
I need- $12.50 or $12.00
Thanks in advance for the input.
i have a form. When the command button is clicked values(numbers) are added.
However, i want the total box to not just show for example, 45.00. but £45.00.
how do you do this?
ya know how you create a field to a table
.createfield ("new field", dbtext, 50)
well how do you do currency? i tried this
.createfield ("new currency", dbcurrency)
this works "BUT" i need it to format it in currency in ms access , it gives it the currecny type but it don't format it.
I am trying to give a label the data format of currency. I select DataFormat | Currency from the properties menu but when i load up my form it still displays integers normally instead of currency like i selected.
I assume I have to do more than simply select currency as the DataFormat?
Thanks in advance
i am using access database , i have 2 fields rate and quantity
what is the best data type in which these must be stored
i am having decimel values but if i use decimel as the dattype then it discards the digit after decimel