Re: [MS_AccessPros] Date field, Please help

 

When you reply, please include the significant parts of the previous messages in the thread.

So you aren't entering a full date, just keying in something like:  02/2017?

I tried a text box bound to a date field and set the Format property to mm/yyyy. When I enter 02/2016 the table stores the value 02/01/2016.

Regards,

Duane

---

From: MS_Access_Professionals@yahoogroups.com <MS_Access_Professionals@yahoogroups.com> on behalf of kenaf42@yahoo.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com>
Sent: Thursday, January 18, 2018 3:25 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: Re: [MS_AccessPros] Date field, Please help

 

Form has many code in the form but nothing for this field. If I formated for mm/dd/yyyy no problem but what I really need is just month and the year and as soon I change the format to mm/yyyy then I have problem no matter which year I enter it just keeps changing it to 2018 !!!!!!!!!

Thank you for your reply

__._,_.___

---

Posted by: Duane Hookom <duanehookom@hotmail.com>

---

Reply via web post

•

Reply to sender

•

Reply to group

•

Start a New Topic

•

Messages in this topic (4)

---

Have you tried the highest rated email app?

With 4.5 stars in iTunes, the Yahoo Mail app is the highest rated email app on the market. What are you waiting for? Now you can access all your inboxes (Gmail, Outlook, AOL and more) in one place. Never delete an email again with 1000GB of free cloud storage.

---

Visit Your Group

• Privacy • Unsubscribe • Terms of Use

.

__,_._,___