Type Mismatch Error

[conton]

Hi there!

I get a the Type Mismatch runtime error when the following code runs in Access:

Me.Textbox1 = Me.Textbox2 * 136.4 - (Me.Textbox2 * 136.4 * Me.Textbox3)

The textboxes are formatted as follows:

Me.Textbox1 = Currency
Me.Textbox2 = General Number
Me.Textbox3 = Percent

So I assume the problem is that my equation is multiplying a general number with a percentage and Access isn't converting the percentage into number form (eg. 15% = 0.15).

Any ideas on how I can make this work?

Thanks in advance!

 

[Montez659]

Try this:

Me.Textbox1 = Ccur( Me.Textbox2 * 136.4 - (Me.Textbox2 * 136.4 * Me.Textbox3))

 

[Joe4]

Are these bound or unbound text boxes?
Where are you placing this code?

 

[Montez659]

Also, add .Value to the end of each Me.Txtbox. Like:

Me.Textbox1.Value

 

[conton]

Try this:

Me.Textbox1 = Ccur( Me.Textbox2 * 136.4 - (Me.Textbox2 * 136.4 * Me.Textbox3))

"Compile Error: Expected: Identifier"

 

[Montez659]

Yeah, my bad, you grabbed it then I edited it. Go back and look at it now.

or, maybe you got the good code. But try the .value.

 

[conton]

Yeah, my bad, you grabbed it then I edited it. Go back and look at it now.

or, maybe you got the good code. But try the .value.

"Run-time error '424': Object Required"

 

[conton]

Are these bound or unbound text boxes?
Where are you placing this code?

They are all bound. The code is in Form_Current.

 

[Montez659]

I shall yield the floor to Joe since he asked the correct questions.

 

[Joe4]

I re-created the layout, and this code works for me:

Private Sub Form_Current()
    Me.TextBox1.Value = Me.Textbox2.Value * 136.4 - (Me.Textbox2.Value * 136.4 * Me.TextBox3.Value)
End Sub