Results 1 to 2 of 2
  1. #1
    burrina's Avatar
    burrina is offline VIP
    Windows 7 64bit Access 2010 64bit
    Join Date
    Oct 2012
    Location
    Freeport,Texas
    Posts
    1,383

    Unbound Combobox show current month

    I tried using this code, no worky! Month(Now()) the combobox is name CurMonth it displays the number 3 instead of March???



    Figured it out, Format(DateSerial(Year(Date()),Month(Date()),Day(D ate())),"mmmm ")
    Last edited by burrina; 03-08-2013 at 01:45 AM. Reason: Got it

  2. #2
    amrut is offline Expert
    Windows 7 64bit Access 2010 32bit
    Join Date
    Jun 2012
    Location
    India
    Posts
    616
    Try Monthname(Month(Now()))

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

Similar Threads

  1. Unbound Combobox Filter By Date Criteria
    By burrina in forum Forms
    Replies: 8
    Last Post: 01-04-2013, 02:24 PM
  2. How to get a specific number for the current month?
    By Ronald Mcdonald in forum Access
    Replies: 1
    Last Post: 06-14-2012, 11:55 AM
  3. Showing dates in current month only
    By fistja in forum Queries
    Replies: 2
    Last Post: 04-09-2012, 10:17 AM
  4. Current Month and Year-To-Date
    By DSnipeFunk in forum Access
    Replies: 4
    Last Post: 05-31-2011, 11:38 AM
  5. Current month in a field as default
    By leandrosarno in forum Access
    Replies: 6
    Last Post: 02-09-2010, 05:40 AM

Tags for this Thread

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