I have several Access forms in an mdb that displays the default date(). They work fine in the mdb but when I create a mde for distribution to a PC without Access, the forms don’t display the date but show instead #Name in the field. I reviewed the date() function in Help which indicates it is the system date which I assume is the PC date. The PC date is displayed and is correct. Does anyone know what is going on with this date?
