calculation in form by entering a number - Formula problem

E

esparzaone

What I want to do is this : when I enter a number in a form field I want it
to automatically double its value? Is this possible and how.
 
M

Martin J

Yes, When do you want to double the value? When they leave the field then in
on lost focus vba code put me![fieldname]=me![fieldname]*2. There are many
options as to when to double just look at your properties of the field and or
form to choose when.
 
E

esparzaone

one more question - the predesigned format for percentage multiplies it by
100. How would you override that? meaning right now I enter 4 and it she
400.00% and I want it to look like 4.00% Is there a way to do this - thanks
for all your help I am a newbie
 
E

esparzaone

how come when I use the mulitplication if I click again on the field it
doubles again. Is there a way to stop that? I appreciate all your help
 
L

LGC

how come when I use the mulitplication if I click again on the field it
doubles again. Is there a way to stop that? I appreciate all your help
Click to expand...

I'd suggest using two fields, one to enter the number and the other to
reflect the calculation. Set the properties of the calculated control such
that it cannot be edited.

LGC
 
Top