P
Peter Hibbs
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.
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.