Access 2013 Form TextBoxes with functions not calculating

[sneuberg]

Our textboxes which have functions such as Count, Dcount, CurrentUser stop working from time to time. When they don’t’ work, none of them work; they don't work on any of the forms in the system. Clicking on the textbox or pressing F9 will cause the data to be shown for the current record. This issue was discussed on the Stackoverflow forum about a year ago and was left with the suggested workaround:

Private Sub Form_Activate()

Me.SetFocus
SendKeys "{F9}"

End Sub




This seems to work, but somehow this just doesn't look robust to me. Is this workaround ok? Can anyone suggest a better fix? Anyone know why this is happening?

[Missinglinq]

This problem has been recognized for quite a while, now, and the cause, amazingly, has been found to be PCs that are left up and running for extended periods of time! Doing a cold reboot always seems to solve the problem, but there reportedly has been a hotfix issued by Microsoft. Running v2007, I have no need for it ans so don't have a download link.

An no, the workaround really isn't 'OK;' using SendKeys has always been problematic, and even more so with later versions! Since Access 2007, unless a previous version of Access is also installed on a machine, the use of Sendkeys may fail, with the important word being may; sometimes it works and sometimes it doesn't!

Linq ;0)>