Results 1 to 2 of 2
  1. #1
    Dave_D's Avatar
    Dave_D is offline Advanced Beginner
    Windows 10 Access 2010 64bit
    Join Date
    Aug 2015
    Posts
    67

    Short Date


    I'm trying to code to alter my field (Modified) with a Data Type of Date/Time in my table (Documents) to be Short Date but seem to find the correct syntax. My statements reads as follows:

    CurrentDb.TableDefs("Documents").Fields("Modified" ).Properties("format", "Short Date")

    What's the correct syntax?
    Thanks!

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,815
    Why bother? I never set format properties in table. I set format in textbox on form or report.

    Code is more complicated. Review https://stackoverflow.com/questions/...ype-and-format
    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. Short Date Not Playing
    By dynamictiger in forum Programming
    Replies: 3
    Last Post: 05-06-2019, 03:40 PM
  2. Convert date from short date to general date
    By cebrower in forum Access
    Replies: 4
    Last Post: 04-24-2019, 08:08 AM
  3. Windows 10 and short date format.
    By NorwegianSiggy in forum Access
    Replies: 1
    Last Post: 09-04-2015, 01:34 PM
  4. How to add Short Date to Field
    By nono5551212 in forum Access
    Replies: 2
    Last Post: 06-06-2014, 10:55 PM
  5. Short date comparison
    By andy101 in forum Programming
    Replies: 2
    Last Post: 03-17-2011, 04:36 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