Prev: Date and Time not updating
Next: Dfirst and DLast function
From: Peter Hibbs on 10 Oct 2008 06:14
Access 2003 (SP3).

I have a Continuous form as a subform on a main form. The Continuous
form has several bound controls, i.e. Text, Currency and Date/Time.
The Default property of the date/time field is set to =Date() as I
want today's date inserted when the user starts a new record.

I have set the form's Fetch Defaults property to No because I don't
want the various default values to appear in the new record at the
bottom of the form (it confuses the users).

The problem is that, for the date/time field ONLY, the default date
value appears in the new record. The other fields default values do
not show (as they shouldn't). I know I can do this in code (and I
probably will have to) but I am wondering if there is something else I
need to do for a date type field or is this yet another bug in A2003.

Peter Hibbs.
 | 
Pages: 1
Prev: Date and Time not updating
Next: Dfirst and DLast function