Calculated fields not displayed in Access - a disastrous bug

[hmlhml]

Oh I hate this sort of thing. I have an access database that has been working fine, but then, with no input on my part, decided spontaneously to change its behaviour so that calculated fields no longer display. I found the explanation:

http://social.msdn.microsoft.com/Fo...not-calculating-until-clicked?forum=accessdev

It turns out it's a known (and now at least acknowledged) bug, for which it doesn't look like anyone at Microsoft has been able to come up with a solution. I'm really irritated because I've put a lot of effort into this Access application and now we're having to explore options as drastic as giving up on Access altogether. It's a huge mess.

 

[SkipVought]

....and the question is?

 

[hmlhml]

Sorreeeee!

Primary question is:
(1) If anyone here knows a work-around for this that the people in the other thread haven't found, I'd be very grateful.

Secondary reason for posting is:
(2) I've just wasted half a week trying all sorts of silly approaches and wondering what triggers a calculated field to be calculated and displayed, and I'm hoping that by spreading the word about this issue (assuming my problem has the same cause) (a) others will be spared the same hassle, and (b) Microsoft might give fixing it a higher priority.

 

[SkipVought]

Since this is not an MS Office question, but rather an MS Access FORMS question, I'd suggest posting this question in forum702.