Using a calendar in a text box on a form

[crowegreg]

I've created two text boxes on a form. Both are formatted with short date. When the form is opened, only one text box is visible. The focus is set on the visible text box. Using the mouse, the user can select the date from the pop up calendar. All this works correctly. What I'm trying to do is get the second text box changed to visible after the first text box has a date within it. I've tried entering code in both the on click and after update events within text box 1, but nothing seems to work.



Thanks in advance!!

[June7]

User must commit the entered value to the field before the AfterUpdate event will trigger. This usually means pressing tab or enter key.

The Click event works for me.

Me.text2.Visible = True

[CJ_London]

What I'm trying to do is get the second text box changed to visible after the first text box has a date within it.

you could use the change event

I've tried entering code in both the on click and after update events within text box 1, but nothing seems to work.

what does 'nothing seems to work' mean? nothing happens? you get an error? screen goes blue?

[Micron]

The change event will fire after typing even just one character and upon each subsequent typed or deleted character, so that might cause unexpected behaviour. Unless you know of a way to prevent typing in the control while still allowing the use of the calendar, it doesn't sound suitable here. As June7 says, the after update wont' fire until focus moves off of the control. Try the textbox.dirty event (and maybe test for a valid date versus garbage text). I'm assuming your control is bound to a date field:

If IsDate(Me.Text1) Then
    Me.Command1.Visible = False
End If