Full Version: Calculate Average while user types
UtterAccess Forums > Microsoft® Access > Access Forms
fb7894
I have a user form with 4 textboxes.
- Revenue Year 1
- Revenue Year 2
- Revenue Year 3
- 3-Year Avg
'd like to calculate the 3-Year Average as the user types in the data in any of the 3 Revenue boxes.
I'm using the Key Up event. But it is not working. Until I exit the textbox, the value for the box is the original value.
How do I properly set this up? Thank you.,
Alan_G
Hi
'd imagine you'd need to use the Change event of the text boxes to perform your calculations........
pbaldy
You would also need to use the .Text property of each, rather than the default .Value property.
This is a "lo-fi" version of UA. To view the full version with more information, formatting and images, please click here.