Problem with bound DataCombo and Masked Edit controls when changing their contents

Problem with bound DataCombo and Masked Edit controls when changing their contents

Post by Dave Matthew » Sat, 20 Nov 1999 04:00:00

Hi folks,

        I'm having a problem in VB6 whereby ADO does not immediately notify the
underlying recordset that a field has been changed, where the field in
question is represented by either a DataCombo or a Masked Edit Textbox.

        Here are the symptoms I am observing (when connected to an SQL Anywhere
DB): When I use a *standard* TextBox as a bound control and the user
changes its contents and then tabs off, ADO immediately notifies the
underlying recordset that the field has been changed (and the
ChangeFieldComplete event is fired). This is good - this is exactly what
I want.

        However if I use either a DataCombo or a Masked Edit Control, the
change of field is not notified until the user actually moves to another
*record*. Why should this be? I can get round the problem by reinforcing
a change of field by using...

rs![fieldname] = DataCombo1

        ... in the data combo's Lose_Focus event but if you have a form
containing several data combos (and/or Masked Edits, which exhibit the
same problem) this is rather inelegant.

        If anyone has any answers, I would be most grateful!



Dave Matthews

'New Avengers' and 'Professionals' sites at:


1. problems with Mask edit controls bound to data controls

To control user's input, I would like use Mask edit.
On my form I have a button, to add a new record, but when VB execute
I have a validation error and after a run-time error, with the empty
field (His mask is ?######), and I can't resume this error.

Somebody has an idea where i'm mistaking (i think it's possible to
add a new records with this control.

        Thank Your for your help

        Arnaud - France - Paris

2. Tools for database documentation

3. Bound masked edit controls

4. MSDTC errors

5. bound masked edit control

6. RDBMS INGRES query (locking) problem

7. Masked Edit Control and Remote data control problem

8. sometimes get 2 sqlturbo processes (?)

9. ADO Bound Masked Edit Re-Bind

10. Problems with bound Masked Edit

11. Masked Edit Bound to DB Problem

12. masked Edit Control Problem

13. Masked Edit Control date type problem