Results 1 to 2 of 2
  1. #1
    wes9659 is offline Advanced Beginner
    Windows 8 Access 2010 64bit
    Join Date
    Apr 2014
    Location
    Dover, Ohio
    Posts
    88

    Adding Long Date to Input Mask

    Once again the easiest things stump me the most lol and I am sure this should be a fairly easy fix. I am trying to use input mask for a date I do not have option for long date. I want to create and add to my input mask selections for future use. I want it to read like this example where actual written month is used: July 4, 2015. I have tried "mmmm dd"," yyyy" but that does not seen to work. Hopefully someone will be able to shed some light on this issue. Once again many thanks for everyone’s help.

  2. #2
    wes9659 is offline Advanced Beginner
    Windows 8 Access 2010 64bit
    Join Date
    Apr 2014
    Location
    Dover, Ohio
    Posts
    88
    I have figured it out on how to do achieve the July 4, 2015 code I wanted. First I added my DOB field to query that I will be using to populate report. I created this calculated field (See attached Screen Shots.
    Expr1: Format([DOB],"mmmm dd"", ""yyyy")

    It works great thought I would share on how I did it Click image for larger version. 

Name:	Calc Field.jpg 
Views:	5 
Size:	39.1 KB 
ID:	19701Click image for larger version. 

Name:	Result.jpg 
Views:	5 
Size:	40.1 KB 
ID:	19702

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

Similar Threads

  1. Input mask
    By scorpion99 in forum Access
    Replies: 4
    Last Post: 02-21-2014, 02:18 AM
  2. Date Input Mask in Query?
    By DelbyJones in forum Access
    Replies: 3
    Last Post: 09-01-2012, 11:08 AM
  3. Input Mask
    By qbc in forum Access
    Replies: 2
    Last Post: 01-20-2012, 03:27 PM
  4. Custom (?) Date Input Mask
    By SeaTigr in forum Access
    Replies: 3
    Last Post: 11-07-2011, 02:40 PM
  5. Input mask
    By doobybug in forum Access
    Replies: 2
    Last Post: 06-17-2009, 09:40 PM

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