>I have a grid, whose record source is a cursor that contains a numeric field (nDayOfWeek) representing the day of the week (i.e. the number returned by DOW() ). The Day column of the grid has nDayOfWeek as the control source, and I added a combobox whose row source is a list of values corresponding to the CDOW() values.
>
>The problem is that I'm drawing a blank on how to get an unselected cell to properly display the verbal day of week instead of the stored numeric value. I tried using an expression in the control source in combination with an array, but then the combobox wouldn't drop down any values when selected.
>
>Any help would be appreciated. :)
Check Marcia Akins paper referenced in message #
1318887 and in that thread message #
1319268 may be of help.
If it's not broken, fix it until it is.
My Blog