Multi-Column Value List Combo box issue?

[prabha_friend]

Requirement:

01/01	1st Term (Jan to April)
01/05	2nd Term (May to August)
01/09	3rd Term (September to December)

Control Source Field Type: Date/Time
Column Count: 2
Column Width: 0;2.5
All are working well until I set the Control Source Field property but changes when I bind the combo box to the "Term" field (Date/Time)
Hope you understand...
Thanks

 

[Pat Hartman]

If you are entering the Term as day/month, it cannot be a datetime data type.

 

[prabha_friend]

If you are entering the Term as day/month, it cannot be a datetime data type.

The current year gets auto-applied...

 

[Pat Hartman]

Doesn't matter. If the field in the RowSource is ACTUALLY as listed, it is a string. It is not a date.

 

[Ken Sheridan]

The current year gets auto-applied...

It looks to me like you might be assigning a date of the first of the month to the column, but returning it in the control formatted as "dd/mm". If so, I'd suggest that you return three columns in the RowSource property: The actual value of the column as the first column, the formatted value as the second column, and the string expression as the third. Set the control's BoundColumn property to 1, its ColumnCount to 3, and its ColumnWidths to something like 0cm;2cm;5cm (experiment to get the best fit, but be sure that the first column's dimension is zero to hide it).