Are you getting the data file from a mapped drive? Try using the UNC path. The server will probably not be able to see your mapped drives when you are...
You could either use an input mask, (See Input Mask Property in Help files for details of options) or for a more user friendly way, check the length on the After...