Hide and show tekstbox

[Patience]

Hi,



I would like a particular textbox to only be visible, when a new record is being filled out - before the record is saved.

So when existing records are shown in the form, this textbox is invisible.

How can this be done?

Thank you very much!

[Datagopherdan]

You can try doing something like this on the form's current event.

Dim intNewRecord As Integer
'Check to determine if new record

intNewRecord = IsNull(Me![ID])
If intNewRecord Then
    Me!MyField.Visible=False
Else
    Me!MyField.Visible=True
End If

[Patience]

Works perfect!

Thank you very much.

[Datagopherdan]

Glad you got it working.

Works perfect!

Thank you very much.