Results 1 to 3 of 3
  1. #1
    trident is offline Competent Performer
    Windows 8 Access 2010 64bit
    Join Date
    Apr 2014
    Posts
    141

    Date and Time not showing properly

    I created a form where in the Current Date and Current Time should appear.



    However, whenever you open the form, only the time appears, only when you click on the Date/Time field will the Date and Time appears.

    When you click another field in the same form the Date/Time field returns to the Time only.

    What I need is for the Date and Time to appear together.

    My option for the Date and time in the table is General Date.

    Thank you in advance for the assistance.

    Trident

  2. #2
    CJ_London is offline VIP
    Windows 8 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,845
    look at formatting the control

    the format property would be something like

    dd/mm/yyyy hh:nn:ss

  3. #3
    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
    How, exactly, are you populating these two Controls?

    Linq ;0)>

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

Similar Threads

  1. Replies: 7
    Last Post: 09-02-2014, 08:18 AM
  2. Replies: 6
    Last Post: 05-06-2013, 04:49 PM
  3. Report not showing properly
    By ashu.doc in forum Reports
    Replies: 7
    Last Post: 10-08-2012, 07:27 AM
  4. Replies: 0
    Last Post: 10-11-2010, 02:40 AM
  5. Showing date and time when importing to access
    By timpepu in forum Import/Export Data
    Replies: 0
    Last Post: 05-07-2009, 07:13 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