I have a form, which has a number field accepting only numbers. I am trying make it accepting formula (ex. =4+5) into the field, like in Excel, can this be done?
Yes it can, just enter the formula in the control source in the data tab of the properties window. One note of caution, you can only reference values that access will be able to find in the record source of the form otherwise you will need to use a DLookUp function to get the value you need.
What I would like to do is to enter the formula directly into the field, the formula is not fixed, it will change, like this time it's 4+5, next time may change to 2+2. And after it accept the formula, it will calculate the result and save the result (as a number) into the underline bounded field of a table.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.