6/20/2023 0 Comments Macfly pro stuck on calculating![]() Type the following to remove the framework:.When I use the above code to apply to format all controls (extra control not needed anymore) the problem is back. When I only format the one control it works. Of course a simple solution is to not make the background black but another "problem" is that when you focus a textbox the background is not visible anymore through the textbox and that doesn't look good. ![]() The above seems to work, but the disadvantage of this method (using one control to display the selected state) is that when you set the color of the control to black and the other controls have black text, you can't read the text. When I press the edit-button and instantly move the mouse over a conditionally formatted field on the subform, it keeps blinking/refreshing untill I move the mouse away from the subform or to a non cond.formatted field on the subform. When I press the button and don't move the mouse over the subform, no problem. On the form there is a button which does a subform.allowedits = true The subform has conditional formatting to highlight the selected record, but I have formatting on every field. I have exactly this problem (Access 2010). LogError Err.Number, Err.Description, "HighlightRow" FormatConditions.Add acFieldValue, acEqual, """" &. FormatConditions.Add acFieldValue, acEqual. If Not IsNull(.Value) And Not IsEmpty(.Value) Then ' scroll back to the previous record to see that, sadly, it is stillįunction HighlightRow(Ctl As TextBox, Optional HLColor As Long = DefaultHLColor) 'vv ' highlighted record is no longer visible, then select a new record, and ' a record (which gets highlighted), then we scroll the form so the The problem with Refreshing the form occurs when we select ' (2002, at least) does not have a rock solid implementation of conditional ' Notes : We could simply Refresh the form in the OnCurrent event, but Access ' 5) Add the following to the form's OnCurrent event: ' 2) Set Enabled = No, Locked = Yes, BackColor = ]) ' Usage : 1) Add a textbox bound to a unique field (preferrably the primary key) ' Purpose : Highlight the detail section of a continuous form. ![]() Private Const DefaultHLColor As Long = 10092543 'RGB(255, 255, 153) Light Yellow ![]() I'll give you a quick example function that shows the technique: I'm not entirely sure why this works but it does. Manually add and delete the conditional format itself. In those cases, I go with my other option Obviously, this won't work if you are trying to differentiate controls on a continuous bound form. When I've run into the problem I've solved it using two different approaches:ĭitch the conditional formatting and apply the format manually through code (ie, via the Form_Current event, After_Update event of a dependent control, etc.). I've had similar problems when using conditional formatting. However similar types of complex controlsources are repeated elsewhere in the app and don't cause a problem, and even this particular control causes no problems on other machines.Īlso for debugging purposes - is there any way to find out what exactly is happening step by step when Access reports that it is "Calculating. The controlsource of the Textbox is admittedly not trivial, it consists of an IF and also uses a VBA function. There is no MouseMove, MouseDown or MouseUp event for this control, nor for any other control. Naturally the textbox is blank till after being released, thereafter it shows the correct data. The textbox shows some readonly financials data. So long as you move the mouse over this textbox you can release the screen and everything works as normal. Then narrowed the jiggling down to one particular Textbox. We took a look and found this to be true, except we noticed that you could "release" the screen again by jiggling the mouse around a bit. " showing in the bottom left hand corner. On one workstation (Access2K3, happens to have a touchscreen), on one of the key forms, the user reported that it was hanging or freezing with "Calculating. We're experiencing this fault on a customer's site.
0 Comments
Leave a Reply. |