Improving continuos form calculated field display....

[Atlas]

I have a continuos form where from about 8 numeric values in each row, out
of the database, a calculated field is displayed.
As it is not part of the db and while using a continuos form, the only way
to display correctly the value, is to stuff a function in the control source
of the calculated filed textbox ( Say control source = calcValue()).
This works but is very slow and executed only when idle, as a result while
scrolling with the mouse and buttonstilldown, the fields is empty until
buttonup.
Is there any trick to speed up?

I've tried unbound the calculated textbox and to call the function from
form->Current, but it doesn't work........

Any hint?

Thanks

 

[Jeff Boyce]

Atlas

I don't know if it would be any faster, but another approach would be to
build a query that returns the values and does the calculation, then basing
your form on the query.