so when u are using query for ms access and in where clause no need to put format function for date time field, no matter in regional setting which ever is format of date time.
example
select fieldname from table_name where datetime_field=some_condition
(no need to convert the datetime_field to any other format like mm/dd/yyyy or dd/mm/yyyy).
control on the form will by default take regional settings date time format.
