text box question

  • Thread starter Thread starter R Kroeger
  • Start date Start date
R

R Kroeger

I am trying to set up a form that will have a text box that will be an entry
for currency, another text box that will have a percentage amount entry
(like a surcharge or tax) and a third box that will display the total. I
have worked for hours and can't get this to work. Am I asking for something
that isn't doable? Any help is appreciated.
Russ
 
Are you familar with VBA coding? There are events on the text box control
that you can use, such as "On Lost Focus" or "On Exit". Within one of these
events (by the way EXIT executes first before LOST FOCUS), you can apply the
necessary math.

HTH

--
Rob

FMS Professional Solutions Group
http://www.fmsinc.com/consulting

Software Tools for .NET, SQL Server, Visual Basic & Access
http://www.fmsinc.com

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
 
so you are entering a "money" amount, and entering a percent? and you want
the third control to display the total of the money + percent-of-money, but
*not* save that calculated value to the underlying table?
if you're entering the percentage as a number value: typing .25 instead of
typing 25%, then you can set the Control Source of the third control as

=[MoneyControlName] + ([MoneyControlName] * [PercentControlName])

every time you change either the money or the percent number and exit that
control, the third control should automatically recalculate. and it should
also automatically recalculate as you move from one record to another, and
another, etc.

hth
 
Back
Top