calculation in form by entering a number - Formula problem

  • Thread starter Thread starter Guest
  • Start date Start date
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.
 
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.
 
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
 
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
 
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
 
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

Enter Parameter Value in Access Form 0
access form 1
Make table query: [Enter 1] AS Test 1
Excel Sequential Numbering System 0
Access Field won't show as currency in the form, shows just a number (but works fine in the query) 1
Populate 'To' recipient on custom mail form 0
Enter a dot between numbers 1
Access Query problem 1

Back
Top