I have a form in access that has several textboxes with calculated values (VBA function, returns variant(always currency) value). When i open the form (and other forms that use calculated fields like this), it won't show the contents of the textbox. The textbox always has a value (either 0,00 (valuta type field) or calculated price (subtotal, BTW (taxes) and total price)).
It starts showing the values in the textbox when it gets the focus (cursor on it/click on it) for every field, until i go to the next/previous record or close the form. When the form is closed and later reopened or gone to the next record (see onCurrent function), if the calculated field has focus when switching records/(re)opening only the field with focus shows it's value. All other calculated fields keep hiding their values until they get focus (once) again.
Anybody knows of this problem and how to solve it (permanently)?
BTW, i'm using windows vista 32-bit with Access 2007 on this project.