auto date adding

[Steve]

I wish to automaticaly add 14 days to a date ie if i enter 21/11/05 in a
start date field it would auto add 14 days so it was 02/12/05 in an end date
field.

I think it would look like this....

=Format(DateAdd("d",+14,[start]))

if so where would i place this? i have tried properties (for the field) and
all the fields i could find there 1 at a time to no avail.

Help please!!

TIA

Steve

 

[Marshall Barton]

I wish to automaticaly add 14 days to a date ie if i enter 21/11/05 in a
start date field it would auto add 14 days so it was 02/12/05 in an end date
field.

I think it would look like this....

=Format(DateAdd("d",+14,[start]))

if so where would i place this? i have tried properties (for the field) and
all the fields i could find there 1 at a time to no avail.

Place it in a text box's ControlSource property.