No AutoExpand in Combobox using ANSI92

[Gibson]

Following a book I read I add new columns (fields) to an existing table in
via code in Access2003 I should set the SQL Server Compatible Syntex to
ANSI92 in the Options/ TablesQueries tab. When I do this I notice the
AutoExpand for combo boxes no longer works. Is there a way around this? Do
I need the ANSI92 compatible selected to add new fields to an existing table
through code?

 

[Allen Browne]

Try adding DISTINCT to the combo's RowSource query statement.