I have a very puzzling problem with my data and the MaskEdBox. I have data from an Access database connected with ADO. When the form loads, 5 textboxes & 1 MaskEdBox display data. You can move through the records, add new, edit, undo and save. I am working with a very small test database(about 10 records). My MaskEdBox is for the Date. Here is the problem;when I select edit, some of the dates are displayed and for some records the date is blank. It is the same records that display date/don't display date everytime. I looked at my data to see if I could spot something out of place between the ones that don't display, but I can't see anything out of the ordinary. This is my code for Edit:
Code:
Case cmdedit
        Highlight Text1(1)
        With MyRecSet
            If (.EditMode = adEditNone) Then
            If (lTotalRecords > 0) Then
                    vMyBookMark = .Bookmark
                Else
                    vMyBookMark = ""
                End If
                Text1(0).Locked = True
                Text1(0).BackColor = vbYellow
                Text1(1).Locked = False
                Text1(1).BackColor = vbYellow
                Text1(2).Locked = False
                Text1(2).BackColor = vbYellow
                Text1(3).Locked = False
                Text1(3).BackColor = vbYellow
                MaskEdBox1.Mask = ""
                MaskEdBox1.BackColor = vbYellow
                MaskEdBox1.Text = MyRecSet.Fields.Item("Date") & ""
                MaskEdBox1.Mask = "##/##/####" 
                Text1(5).Locked = False
                Text1(5).BackColor = vbYellow
                navigateButtons ("00000110000")
                Text1(1).SetFocus
            End If
        End With
Can anybody tell me what is going on? I can't figure out why it is doing this.
Thanks