OK has anyone ever experience this problem? When a record is saved in an Access database, the date is saved a 2/3/2004 (Feb.03/2004) which is correct. However, when it is displayed, using Format(RSQRY("CheckInDate"), "DD-MMM-YYYY"), it display 02-MAR-2004. Anyone ever experience this?

I believe your use of the -MMM- is what dictates the month token. Use -MM- instead.