I have successfully laid out the format of the userform and the rest of the necessary elements for this project. Initial testing works ok, with some refinement remaining. But when I call up a record to update, date fields display the serial number pulling from the worksheet, not in date format.
Several searches, and attempts, to adjust the textbox display have been unsuccessful. I tried inserting a calendar, as some Google searches and other forum comments mentioned, but that doesn't do it either.
I'm not quite certain what the problem is, or what the appropriate next steps are to correct this. What am I missing or doing wrong?
Thanks in advance for any and all assistance.
Code
Private Sub txtDate_AfterUpdate()
If IsDate(Me.txtDate.Text) Then
Me.txtDate.Text = Format(Me.txtDate.Text, "mm/dd/yyyy")
End If
End Sub