Field Update Question

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello. Normally, when entering data into a field, it doens't update until
you lose focus on that field. Is there a way to retrieve the value of a
field as characters are being entered instead of using the fieldname.value
property?

Thanks!
 
If you are using a form, you can use the Text property of the control in its
Change event.
 
Can you explain? The change event doesn't seem to fire until you lose focus
 
The Change event of the control fires with each keystroke.

Example:
Private Sub Text0_Change()
Debug.Print Me.Text0.Text
End Sub
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

error on update table WHERE date comparison 0
Missing Drop Down command in Visual basic 1
Excel Excel 2013 cell text hidden whilst typing 5
Edited data record to be inserted as a new data record under the same PO number in Microsoft Access 0
Eliminate prompt in requery of subdatasheet in vba 6
importing data 1
Update Query question 2
MS Access Record locking 5

Back
Top