I want to be able to enter, for example "17", in a date field and have that converted to the current month and year (e.g. 17 Dec 1999). Any suggestions?
Hiya Geekette,<br>
<br>
This is as far as I got on your question. Used as a control source for a control, it results in a date formatted control.<br>
<br>
Month(Now()) & "/" & [Form control Name] & "/" & Year(Now())<br>
<br>
Hope this helps!<br>
Drew
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.