cnurse wrote: Arnie, try this simple change... mydate = Format(cDate(Me.editHireDate.Text.ToString), "Short Date") Nursey I appreciate the input. I used your idea/code (even took off the "ToString") and still *&*^*& What I'm getting in return is what has caused me to look at options, settings and so on... "Cast from string "01151995" to type 'Date' is not valid. Arnie