Unable to get "Expression Is" conditional formatting to take effect

[GraeagleBill]

My expectation is that lngCurRecID will remain set to the current record ID until such time that the function is complete, certainly until the user replies to the prompt:


If MsgBox(strPromptMsg, vbYesNo)

My belief being that the DelTran code is "parked" until the user responds.

[June7]

Doesn't alter my comment in previous post.

I suspect the function called by Conditional Formatting is run before the delTran function in which case the variable is 0. I expect the Conditional Formatting is triggered only when some event takes place, such as opening form or editing a textbox. The fnCurRec function cannot be executed until delTran function is finished, at which point the variable is again back to 0.

Suggest you have function delTran set textbox instead of variable. Then have the Conditional Formatting refer to the textbox.

However, the delTran function should be so fast, user will likely see barely a flicker in change of colors as the textbox value is changed during the code execution.

[GraeagleBill]

the delTran function should be so fast

DelTran execution is suspended pending user reply to confirm or cancel transaction deletion.

See my post #9 wherein I reported the results of using your text box approach.

While I would assert that the tb value is non-zero during the time the user is being prompted, I don't know now whether Access would even "know" to process Conditional Formatting unless I were to Requery the form.

[June7]

I did a quick test. I have all the controls on a form set with Conditional Formatting based on the value of one control - all are bound to fields. I manually change the value in that one control and only that one control immediately changes. All the others don't until form is refreshed. When I programmatically change value in that one control, not even that control changes. So hope that helps clarify capabilities and limitations of Conditional Formatting.