Date() + 3 Months. Now how do I tell Access.

  • Thread starter Thread starter Kevbro7189
  • Start date Start date
K

Kevbro7189

I know this should be simple but....
I have a Text box that I want to show what date it will be in 3 months.
 
I want the Text Box to display the date it will be 3 months from whatever
date the user is using the program.

I tried to use the equation you posted but I get nothing other than #NAME?.
 
I want the Text Box to display the date it will be 3 months from whatever
date the user is using the program.

I tried to use the equation you posted but I get nothing other than #NAME?.

Set the Control Source property of a textbox on the form to

=DateAdd("m",3,Date())

The code Linq posted works just fine in a VBA module; the syntax is just a bit
different in a form.
 
Back
Top