Marc, Actually, you have the optimum settings here. The "format" is the usual output. the "sequence" is the expected input. If you had YYYY in your sequence, you would be forcing data entry to type all four digits all the time, otherwise the years would be stored as 0003, 0004, 0005, etc, instead of 2003, 2004, 2005.
I'm quite certain this doesn't have anything to do with your problem. Bill On Fri, 8 Aug 2003 07:58:36 +0100, Alastair Burr wrote: >Marc, >I don't know if it will cause any problems but your date sequence contains >only 2 characters for the year and the format contains all 4. >As the format tries to display what's in the sequence you may not be seeing >everything. >The only other thing that might be causing a problem is that your NULL >statement is near the end and not at the start when begin to define the >pairs of settings. If you have some weird null to start with - unlikely, but >not impossible - then you might be getting some odd effect.
