Text box control shows zero length string as text is entered

[GraeagleBill]

What event can be used instead of OnChange such that the control reference reflects that text has been entered? The OnChange event fires as expected with each keystroke but the control referenced as "tbNewDescription" does not reflect those completed keystrokes.

[pbaldy]

You have to use the .Text property in the change event.

[pbaldy]

More here:

http://www.baldyweb.com/ValueText.htm

[GraeagleBill]

I'll have to think of some other way, as the "CheckSaveStatus" function gets invoked when neither of the tb's referenced would have the focus. Access bombs with a 2185 if I try.

Private Function CheckSaveStatus() As Boolean
'*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*
' Check minimum requirements for a save operation
'*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*

CheckSaveStatus = (Len(tbNewDate & "") > 0 And intNewTTypeID > 0 And _
                  (Len(Me.tbNewDescription.Text & "") > 0 Or Len(Me.tbNewMemo.Text & "") > 0))

End Function

This works as originally intended:

Private Sub tbNewMemo_Change()
strMemo = Me.tbNewMemo.Text
If CheckSaveStatus Then ToggleCmdVisibility
End Sub

Private Sub tbNewDescription_Change()
strDescription = Me.tbNewDescription.Text
If CheckSaveStatus Then ToggleCmdVisibility
End Sub

Private Function CheckSaveStatus() As Boolean
'*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*
' Check minimum requirements for a save operation
'*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*
CheckSaveStatus = (Len(tbNewDate & "") > 0 And intNewTTypeID > 0 And _
                  (Len(strDescription) > 0 Or Len(strMemo) > 0))

End Function

Both strDescription and strMemo are Dim'd String and are both initialized and refreshed as ZLS as appropriate.

[pbaldy]

I assume you're using the change event so it changes the visibility while you're typing? The simplest solution is using the after update events rather than the change events, in which case the visibility wouldn't change until the user hit Tab or Enter. If you want to keep it as is, you might be able to use ActiveControl to determine which control has focus, and only use the text property on that one.

[GraeagleBill]

I'll stay with the OnChange so that there's no dependency on the user to take any further action other than to stop typing to be complete. "Turning" on the "SAVE" command button when the required conditions have been met is what the user (read Carol) wants.

[pbaldy]

The boss gets what the boss wants.