Results 1 to 2 of 2
  1. #1
    michaelhare is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Nov 2014
    Location
    Vista, CA
    Posts
    5

    Formating a filtering query

    I have a report that uses a filtering input that filters out data by a given date as shown below.

    In the properties section:

    Record Source: [Daily Activity]
    Filter: [Work Date]>=[Beginning Date: Enter as 01/01/14] And [Work Date]<=[Ending Date: Enter as 01/01/14]
    Filter On Load: Yes



    This results in a box that asks for the values of the Begin and End Dates. I would like to format those boxes to use a mask to accept date input without having to enter the "/"'s or even better the little calendar that pops up.

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,770
    AFAIK, cannot format input popups with an input mask. But I didn't know they would show a date picker. I NEVER use popup prompts. Better to use controls on form for inputs and report reference them.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

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

Similar Threads

  1. Conditional Formating
    By Derrick T. Davidson in forum Reports
    Replies: 3
    Last Post: 07-18-2014, 09:25 AM
  2. Conditional Formating help
    By Mounds in forum Forms
    Replies: 2
    Last Post: 02-10-2012, 11:07 AM
  3. Formating a query
    By lmp101010 in forum Queries
    Replies: 2
    Last Post: 08-17-2010, 05:26 PM
  4. Filtering a Query
    By Brian62 in forum Queries
    Replies: 2
    Last Post: 06-03-2010, 01:46 PM
  5. Filtering a Query
    By jbarrum in forum Access
    Replies: 1
    Last Post: 11-20-2009, 03:03 PM

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