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.
Your post isn't very clear. DO you want the textbox to show the date three months from the current date, or do you want it to show three months from a certain date? At any rate, the syntax would be Me.DateTextbox = DateAdd("m",3,Date) for three months from the current date. Simply substitute any other given date for Date() if you want three months from a given date. -- There's ALWAYS more than one way to skin a cat! Answers/posts based on Access 2000/2003 Message posted via http://www.accessmonster.com
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?. "Linq Adams via AccessMonster.com" wrote: > Your post isn't very clear. DO you want the textbox to show the date three > months from the current date, or do you want it to show three months from a > certain date? At any rate, the syntax would be > > Me.DateTextbox = DateAdd("m",3,Date) > > for three months from the current date. Simply substitute any other given > date for Date() if you want three months from a given date. > > -- > There's ALWAYS more than one way to skin a cat! > > Answers/posts based on Access 2000/2003 > > Message posted via http://www.accessmonster.com > >
On Tue, 8 Jul 2008 21:05:00 -0700, Kevbro7189 wrote: >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. -- John W. Vinson [MVP]
