Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2003
    Location
    Belfast, UK
    Posts
    87

    Unanswered: date format changes when running query

    Hi,

    I've a database that's reading the date from a textbox on a form and storing it in a variable then running the sql for the query but it's changing the date format on the design view of the query to MM/dd/yyyy when the system is set to dd/mm/yyyy.

    Anyone know why this is happening?

  2. #2
    Join Date
    Feb 2004
    Posts
    142
    Open the query in design view and right-click on the problem field and select properties. In the properties sheet you can specify/set a format that you want the query to display the field as.
    KC

Posting Permissions

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