Access: Fill in data (date) from another when entered and empty

Question

Working with MS Access 2016. I have a form with multiple textboxes. I want one of my textboxes (tbx_outTSDatum_BQC) to be automatically filled -if entered and empty- with the value of another textbox (tbx_inTSDatum_BQC). This code does nothing:

Private Sub tbx_outTSDatum_BQC_Enter()
    If Me.tbx_outTSDatum_BQC.Value = Empty Then Me.tbx_outTSDatum_BQC.Value = Me.tbx_inTSDatum_BQC.Value
End Sub

Changing the event from Enter() to GotFocus() does not help. How can I get this working? Thank you.

score 2 · Accepted Answer · answered Jun 15 '18 at 19:35

2

It is Null to check for:

If IsNull(Me!tbx_outTSDatum_BQC.Value) Then 
    Me!tbx_outTSDatum_BQC.Value = Me!tbx_inTSDatum_BQC.Value
End If

answered Jun 15 '18 at 19:35

Gustav

53,498
7
29
55

Thank you! Perfect! If I would have known that "Empty" was the mistake, I would have been able to google it. – Jens Wilken Jun 15 '18 at 19:43

Access: Fill in data (date) from another when entered and empty

1 Answers1