date()

[cybertyk]

how would i go about

string = date() + 3months

?

 

[JamesMcS]

try looking up the dateadd function in the help file, should be what you need...

 

[namliam]

And if you need it to be not a date but a string, use the FORMAT function.

 

[JamesMcS]

Would it be CDate() that OP would want to use? Or does it not make a difference? Depends how it's stored in the table I guess

 

[cybertyk]

Me.Company_Next_Contact_Date.Value = DateAdd("m", 3, Date) was the anwser,

ok next question. when the forms load they always load stupid sizes so i have to click the form to size buttion is there a way to force this on oading of the form?

 

[JamesMcS]

Yep have a look at form.height and form.width properties