How to calculate a formula in a text box? 1

[Hanss]

I have an access form with:

text field "text1"
text field "result"
command button: "button"

If I enter "2 + 5" in text1 and press the button I would like VBA to put the answer: "7" in the result field.

This only puts the formula "2 + 5" in the result field:

Me.result = CStr(Me.text1)

Would really appreciate any help!

Hanss
Zurich

 

[PHV]

I'd use the Application.Eval method.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[Hanss]

EVAL works. Thank you VERY much for your valuable help!

Hanss