Thread: How can I after selecting date on the Calendar autoinsert text into a activex textbox

Hi,

Need help on inserting text. I am currently creating a Registration Page with activex textbox. One of the field that I am creating is the "DOB" and I am putting a Calendar button beside the text box. When clicked, the Calendar button will display a Calendar Userform that allows the user to click on the specific date he wants, after which I hope that the date will be reflected on the textbox. I tried this formula "Textbox1.Text = Calendar1.Value" and it doesn't work, any help here?

Alvin

Hi

try adding the following code to the Calendar form (e.g. frmCalendar) and the data should update when you close the calendar form and return to your Registration form

Code:

Private Sub Form_Close()
    Forms!frmRegistration!Textbox1= Calendar1.Value
End Sub

hope this helps
qff