Listboxes

[dpdeleon]

I've used a rowsource to fill my listbox. Trouble is that the first entry is
always blank (Null). does anyone know how I can remove the first entry so
the list box starts with a valid value?

 

[Joan Wild]

What is the rowsource - a query or table? You can modify the rowsource to
include a WHERE clause that doesn't return the null value.

 

[dpdeleon]

It's simply a select statement that retrieves all of the values. There
really isn't any Null value in the recordset. The problem is that Access
seems to start the listbox with an empty entry.

 

[Jim Kennedy]

That 'select' statement is a query. Click on the 3 dots
(ellipsis, I think) at the end of the property box to edit
the query. Put 'is not null' in the criteria of the
desired column.

 

[Joan Wild]

Access does not start the listbox with an empty entry. Click on the build
button to the right of the rowsource. It will open a QBE window. Run the
query and you'll see that there is a null entry. Just put a criteria of
is not null under the appropriate field so that it isn't displayed.