I have a Microsoft Access 2003 database.
There is a table Customer that contains a field CustomerName that has data type=Text. In the table definition, the Format value for that field=> (display as upper case).
In a form, when I select that text field for a combo box column, it will not display any values in the drop down list. In Design view, when I view the row source, I see the data. But in Form View, when I drop down the combo box, I see a blank column. Why?
Other text fields without any formatting appear fine in combo boxes.
Start Free Trial