>I have a grid that I want to display the day of the week from a date field in a table. I can use CDOW(date) for the column control source, but when I use this in the text1 control source, I get an error.
>What do I use for the control source?
>Thanks!
I'm not sure I understand. You only want the CDOW(datefield) as the ControlSource for your column, not for the textbox in the column. Leave the textbox ControlSource property empty.