Member Avatar for onlyvidya

Hi frnds,,
i hv a form in which i want to calculate balance.I wrote code for this as follows.
But its giving me an error as "Datatype mismatch error". I hv declared bal & amt in database as Currency.Is this proper??If not suggest me some other code plzzzz.
what datatype should I specify for these two variables??
Dim bal, amt As Integer
If (cmbtrans.SelectedItem = "DEPOSIT") Then
bal = 0
amt = Val(txtamt.Text)
bal = bal + amt
txtbalance.Text = bal

End If

  • 3 Contributors
  • 2 Replies
  • 91 Views
  • 1 Week Discussion Span
  • Latest Post Latest Post by sierrainfo

Recommended Answers

All 2 Replies

Member Avatar for ksanthoshmail

Hi frnds,,
i hv a form in which i want to calculate balance.I wrote code for this as follows.
But its giving me an error as "Datatype mismatch error". I hv declared bal & amt in database as Currency.Is this proper??If not suggest me some other code plzzzz.
what datatype should I specify for these two variables??
Dim bal, amt As Integer
If (cmbtrans.SelectedItem = "DEPOSIT") Then
bal = 0
amt = Val(txtamt.Text)
bal = bal + amt
txtbalance.Text = bal

End If

re:
Better You can Use Double
i.e
Dim bal, amt as Double

Because amount are having decimal values.
like 0.00

and also change database Datatype to money or float(in sqlserver2000)

Member Avatar for sierrainfo

You can Use Double

Dim bal, amt as Double ' like 0.00

If you are using MS Access Database not need to change Currency Datatype
or using SQL Server 2000 in database change Datatype to money or float.

Regards

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.