Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
How do I have the current year be a default value in a text box?
- Thread starter phatbeno
- Start date
DonQuichote
Programmer
- Nov 9, 2001
- 980
Code:
=format$(now(),"yyyy")Best regards
Enter:
=Year(NOW())
into the control source field under the data tab of the properties window for the textbox. That should do the trick.
If you can't be "The Best", be the best at what you can!!!
Never say Never!!!
Nothing is impossible!!!
=Year(NOW())
into the control source field under the data tab of the properties window for the textbox. That should do the trick.
If you can't be "The Best", be the best at what you can!!!
Never say Never!!!
Nothing is impossible!!!
- Status
Similar threads
- Locked
- Question
