Results 1 to 2 of 2
  1. #1
    bbmak is offline Novice
    Windows 7 64bit Access 2010 32bit
    Join Date
    Jan 2014
    Posts
    15

    Calendar picker with month/year only

    Hi, I want to know are there a way to make the calendar picker on the form view only show the month/year?

  2. #2
    Missinglinq's Avatar
    Missinglinq is offline VIP
    Windows 7 64bit Access 2007
    Join Date
    May 2012
    Location
    Richmond (Virginia, not North Yorkshire!)
    Posts
    3,018
    No. The Calendar can not only show month and year; you'd have to find a custom Control for this, and I've never seen one. To simply display only the month/year of a Date Field, after leaving the Control, would be simple, if that would serve your purpose. You'd simply enter mm/yyyy in the Control's Format Property.

    It all depends on exactly what you're trying to do, here.

    Linq ;0)>
    The problem with making anything foolproof...is that fools are so darn ingenious!

    All posts/responses based on Access 2003/2007

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 1
    Last Post: 08-13-2013, 09:39 AM
  2. 30 reward dollars per calendar month.
    By NewMexicoNovice in forum Access
    Replies: 2
    Last Post: 05-31-2013, 05:42 PM
  3. Replies: 4
    Last Post: 05-26-2013, 03:28 PM
  4. Financial Year not Calendar Year
    By Kirsti in forum Queries
    Replies: 5
    Last Post: 05-02-2012, 09:11 PM
  5. Month Picker Control
    By DarkWolff in forum Forms
    Replies: 0
    Last Post: 03-27-2012, 11:59 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums