G
Guest
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.
to automatically double its value? Is this possible and how.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
G
Guest
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.
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.
G
Guest
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
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
G
Guest
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
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
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
doubles again. Is there a way to stop that? I appreciate all your help
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