User calculating a field

  • Thread starter Thread starter CAM
  • Start date Start date
C

CAM

Hello,

I want to have an unbound text boxes that the user can make a calculation
similiar to an Excel cell. The use will input the number and hit the enter
button to get the result. For example the use will input the following:
=5*5 and press enter that text box should display the number 25. Now I want
to use the following signs + - / * as well. How can I do this. Thank you
in advance.
 
You can use the Eval function. For more detail, see VBA Help.
You can't use the = sign, it will throw an error. You would use the
control's After Update event to do the calculation.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Unbound text box calculation 6
Clear contents of an unbound text box on a bound form. 2
Calculation/Formula in Forms? 10
Calculating an average on a form 2
Can I calculate from unbound text boxes? 1
Calculate distance between two points (numbers) in a number line 5
MS Access Text Box Control 1
Calculated Field 3

Back
Top