auto date adding

  • Thread starter Thread starter Steve
  • Start date Start date
S

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
 
Steve said:
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.
Click to expand...


Place it in a text box's ControlSource property.
 
Back
Top