Wednesday, November 4, 2009

Access 2003 Listbox: Items invisible

Scenario: Some or all of the items in a Listbox are invisible:

Cause: The properties from the field in the original table from which the data are pulled have format setting in it’s properties.

Solution: Track from which table data are pulled in the SQL statement that populates the listbox. Open the table in design view and check the properties for the current field and make sure that the format propery are empty.