[AccessD] More Date issues

We generally set the display formats to a medium date, which seems to be
fairly uniform and can at least be read everywhere and makes it
perfectly obvious which is the day and which is the month.  Dates can
still be entered in short date format, and the regional settings
interprets that to display it in medium format.  

Charlotte Foust

-----Original Message-----
From: Stuart McLachlan [mailto:stuart at lexacorp.com.pg] 
Sent: Wednesday, October 15, 2003 3:05 PM
To: connie.kamrowski at agric.nsw.gov.au; accessd at databaseadvisors.com
Subject: Re: [AccessD] More Date issues


On 16 Oct 2003 at 8:42, connie.kamrowski at agric.nsw.go wrote:

> OK I tried Dim as String
> 
> it still displays the date in the sub form as a complete reverse. ie:
> 
> 17/10/02 is entered... passed as 10/17/02 to strSQL (verified by 
> msgbox)
> 
> the value saved to the subform is 02/10/17
> 

Not "saved to the subform". 

Do you mean "displayed by the subform"?
Forms only display data which is stored in a table.

I'd look at the Format property of the textbox in the subform for a 
start.   You may still be looking at "17 Oct 2002", but formatted as 
"yy/mm/dd"  

This is one reason I always specifically format controls which 
display dates to  "dd mmm yy" or "dd mm yyyy"













 
-- 
Lexacorp Ltd
http://www.lexacorp.com.pg
Information Technology Consultancy, Software Development,System 
Support.



_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com