Hi Kirk,
>I have century on and am using the rollover function, but our client (big money client) insists that I make the date fields so the user has to enter the complete date 02/19/1998. Right now I am using a text field with a controlsource being a date field from the table/view. Does anybody have a clue how I can do this. I've tried checking the length of the field on valid and it has already changed it to the full length. VFP 5
Since VFP handles dates on its own there's no way in detecting whether the user entered a full date or only the year and decade. If you don't want to use a character bound textbox or do saving the date yourself in the Valid() event, you could alternatively use SET CENTURY and make an uncommon century the default century, maybe 99. Then you can use IF YEAR(.Value) > 9900 to verify whether the user entered 2 digits (in which case VFP applies the default century) or 4 digits (in which case the century must either be 1900 or 2000).
Just an idea...
Christof
--
Christof