access class microsoft training - Default value in a field

The UK's most regular instructor-led training courses.
Training information: access class microsoft training · Courses in microsoft access · Microsoft Access Training
See also · microsoft access training · access vba courses · access database course

Resolved · Low Priority · Version Standard

Default value in a field

Sinéad has attended:
Access Intermediate course
Access Advanced course
Access VBA course

by - delegate Sinéad [15 posts] (2007 Jul 27 Fri, 09:57) Reply

I would like the default value in a date field to be the date that the form is being used so that the user has the choice of keeping that date rather than inputting it manually. how do I do this?

Version	Date	Location	Places available	Book	Next place rate:
Access Advanced 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2008 Oct 24 Fri	Bloomsbury	7	book now	£203	£230
2003	2008 Oct 29 Wed	Bayswater	6	book now	£214	£230
2003	2008 Nov 5 Wed	Southwark	6	book now	£214	£230
2003	2008 Nov 21 Fri	Bloomsbury	6	book now	£214	£230
2003	2008 Nov 26 Wed	Bloomsbury	5	book now	£219	£235
2007	2008 Nov 28 Fri	Bloomsbury	5	book now	£235	£240
Full Schedule: See all 51 Access Advanced course dates. Bookings currently available until 25th November 2009.

RE: Default value in a field

by - trainer Carlos gold contributer [439 posts] (2007 Aug 1 Wed, 11:35) Reply

Hi Sinead

It sounds like you want to default the Date field on the form to the current date.

To do this:

Set the Default value for the Date Text Box on the form to

=Date()

This will always show the current date (as set by the PC's internal clock)

Regards

Carlos