Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2003
    Posts
    11

    Red face Unanswered: Date Entry problem

    I'm also having problem with the Date entry
    Since my country write date in the way of dd/mm/yy, it's giving me problem when entered such format into the table.

    For example: When I enter 25/03/04 it's showing me 03/25/04. It automatically changed to the format of mm/dd/yy. Can someone please help me out? thanks again
    Sunny

  2. #2
    Join Date
    Sep 2003
    Location
    UK
    Posts
    122

    Arrow

    You should be able to set the format in the properties setting of access.

    You should be able to set the date format globally in your windows settings

    There are some settings for office that can be changed when you install it, run the setup from CD to do that.

    Other options: Set a mask in the table and define dd/mm/yy or dd/mm/yyyy and set no format on the form itself.
    Matt the Hat says: "what!?"
    A child of five could understand this! Fetch me a child of five!
    SCARY HARD CHALLENGE: http://www.dbforums.com/showthread.php?threadid=988682

  3. #3
    Join Date
    Sep 2002
    Location
    South Wales
    Posts
    580

    Lightbulb Other issues

    ...and the time may come when you need to be aware of this;

    http://support.microsoft.com/default...;en-us;Q149095
    Windows Server 2003-8 / Terminal Services / SQL 2000 / Access 2003 / Office 2003-7 / Exchange 2003-7 / Blackberry Enterprise Server / AutoCAD / Lambert And Butler / Red Bull

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •