In one of my access forms, I have a ComboBox that contains Weeks which come from a table in my access database. In the ComboBox there is a blank entry which allows the user to choose it and it returns all the weeks in that table.
My code is as follows:
cmbWeekReject.RowSource = "SELECT Week FROM RejectTimeSheet
UNION SELECT ' ' FROM
RejectTimeSheet"
I set the format of my ComboBox to MEDIUM DATE and the field WEEK in the database is also MEDIUM DATE. The problem is that once the recordsource is set I get a SHORT DATE format and not a medium date format in the ComboBox!! Shouldn't the SQL query statement return the same format as in the table??
Please does anyone have any idea!!!
Legs
My code is as follows:
cmbWeekReject.RowSource = "SELECT Week FROM RejectTimeSheet
UNION SELECT ' ' FROM
RejectTimeSheet"
I set the format of my ComboBox to MEDIUM DATE and the field WEEK in the database is also MEDIUM DATE. The problem is that once the recordsource is set I get a SHORT DATE format and not a medium date format in the ComboBox!! Shouldn't the SQL query statement return the same format as in the table??
Please does anyone have any idea!!!
Legs