Results 1 to 4 of 4
  1. 10-17-2011, 09:30 AM #1
    Bhat59
    Bhat59 is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Oct 2011
    Location
    Udupi, INDIA
    Posts
    20

    Auto fill Current year


    Is it possible to autofill the current year in a field with the help of expression builder in forms?
    Reply With Quote Reply With Quote
  2. 10-17-2011, 10:52 AM #2
    Robeen
    Robeen is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    Mar 2011
    Location
    Tulsa, Oklahoma.
    Posts
    1,596
    In the field on the form where you want to see the date - type in:

    Code:
     
=Format(Date(),"yyyy")
    Hope this helps!!
    Reply With Quote Reply With Quote
  3. 10-17-2011, 01:52 PM #3
    Whizbang
    Whizbang is offline Advanced Beginner
    Windows 7 32bit Access 2010 32bit
    Join Date
    Oct 2011
    Posts
    37
    You can also do:

    =Year(Date())
    Reply With Quote Reply With Quote
  4. 10-17-2011, 08:56 PM #4
    Bhat59
    Bhat59 is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Oct 2011
    Location
    Udupi, INDIA
    Posts
    20
    Thank you for your response. I got it.
    Reply With Quote Reply With Quote
Please reply to this thread with any new information or opinions.
« Previous Thread | Next Thread »

Similar Threads

  1. Current Month and Year-To-Date
    By DSnipeFunk in forum Access
    Replies: 4
    Last Post: 05-31-2011, 11:38 AM
  2. Auto Fill
    By Kerrydunk in forum Forms
    Replies: 16
    Last Post: 04-26-2011, 12:15 AM
  3. Auto-Fill
    By sophiecormier in forum Programming
    Replies: 3
    Last Post: 10-02-2010, 08:29 AM
  4. Filet Records by Current Year
    By jbarrum in forum Access
    Replies: 6
    Last Post: 11-19-2009, 11:34 AM
  5. Changing a date to the current year
    By fdnyfish in forum Access
    Replies: 1
    Last Post: 03-01-2008, 08:34 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
  •  

Forum Rules

Other Forums: Microsoft Office Forums