Results 1 to 3 of 3
  1. #1
    NumbersRock is offline Novice
    Windows 10 Access 2010 64bit
    Join Date
    Jun 2022
    Posts
    2

    Post Date and time showing for date only Field

    Hello I have 2 fields (See Images Below)


    They refer to the same source in an SQL database.

    The date and time show correctly in their respective fields until I click to edit them.
    Then it shows the full date and time for both. Any ideas how to fix this?

    I have the date set as short date and time set as medium time.

    Click image for larger version. 

Name:	2022-06-03 14_41_35-tblSessions.png 
Views:	20 
Size:	2.5 KB 
ID:	47968

    Click image for larger version. 

Name:	2022-06-03 14_42_02-tblSessions.png 
Views:	20 
Size:	2.7 KB 
ID:	47969

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    the field is FULL date/time, but the format shows only DATE. But when you edit it shows the full field data.
    Maybe in the form's underlying query, set that field property to :short DAte. (right click, property, format property.)

    if that still wont do it, use: format([myField],"mm/dd/yyyy")

  3. #3
    CJ_London is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,398
    Hello I have 2 fields (See Images Below)
    They refer to the same source in an SQL database.
    Needs clarification - the implication of what you are saying (and also implied from your screenshots) is there is just one field and you are trying to edit the date part in one control and the time part in another. That can lead to complications because if you edit the date part there is a risk you will set the time to 0:00 and edit the time part and you will set the date to 0 (31/12/1899)

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

Similar Threads

  1. Replies: 12
    Last Post: 12-27-2018, 12:48 AM
  2. Replies: 5
    Last Post: 09-16-2018, 04:58 PM
  3. Replies: 6
    Last Post: 04-19-2016, 03:58 PM
  4. Replies: 7
    Last Post: 09-02-2014, 08:18 AM
  5. Subtracting a date/time field from a number to get date/time
    By Lifeseeker1019 in forum Programming
    Replies: 4
    Last Post: 03-28-2014, 12:59 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