thealca, I appreciate you taking the time te help me. The solution checks to see if the field is a date but I also need to make sure that the date wasn't entered incorrectly, i.e. if someone just enters 5/05 I want to display the message to have them re-enter the date. ryanchk

I'm using a VB6 application with an FP Spread control. I need a way to check to see if the date was entered complete and in the right format. This is the idea that I have but does not work: With fpsScr If .ActiveCol = 6 And .ChangeMade Then If .Text <> "##/##/####" Then MsgBox "The date was not entered correctly. Please try again.",_ vbOKOnly, "Incorrect Date Entry" End If End If End With Can someone help me? ryanchk