Set default value of list box to empty or null?

[Budatlitho]

I have a list box in a form whose record source is a query. On opening the form, the first value from the query populates the field. How can I make the default value "blank" or Null? Tried setting the default value to " " and also Null but neither works.
Probably missing something really simple....


TIA
Bud

[Minty]

A list box by definition lists the results of a the query or table in the rowsource.

Either only set the rowsource after something else on the form "triggers" that need or hide it on the same basis.
The only other method is to Union the query with a " " empty value, but that means the user can choose it, which is not probably what you want.

[CJ_London]

might help to show what the sql to your query is and what field (if any) it is bound to. Also if the listbox is the first control based on tab order, and the listbox is unbound or if bound the main form is on a new record, it has the focus so will automatically select the first item in your listbox. If this is the case, change the tab order or create a textbox called say 'parkFocus' make sure it is visible but set top, left, height and width values to 0 and set the tab order to 0