Multiplying text box values - correct syntax

[insomniac53]

I'm trying 'simply' to multiply the contents of two text boxes and put the product in a third. This is the code I'm using:

Me.Controls.Item("TxtBox_A_Deposit").Value = format(CDbl(Me.Controls.Item("TxtBox_A_Percent").Value) * CInt(Me.Controls.Item("TxtBox_AB_Qty").Value), "£0")

but it throws up a Type Mismatch error, even though I'm forcing the data types to fit.
Can anyone tell me what I'm doing wrong?
Thanks.

 

[mikerickson]

A textbox's value is a string, not a number. although your code looks like it takes that into account. Do the Percent and Qty textboxes also force units.
(i.e. put a pound sign or a percent sign in the cell).

try

Me.TxtBox_A_Deposit.Text = Format(Val(Me.TxtBox_A_Percent.Text) * Val(Me.TxtBox_AB_Qty.Text), "$0")
or
Me.TxtBox_A_Deposit.Text = Format(Val(Me.TxtBox_A_Percent.Text) / 100 * Val(Me.TxtBox_AB_Qty.Text), "$0")

 

[insomniac53]

Thanks so much for that. Yes, it works. The "Val" method is one I haven't used before. I thought the "Cdbl" or "CInt" would work, but they didn't. The Percent and Qty textboxes also force units so I will use the same syntax. Again, many thanks. I didn't think I was going to get any sleep tonight.