list box default value

A

Anne-Marie

I have a form containing a list box for which I do not want a default value.
I can not figure out how to make the list box "not have" a default value.
Can someone help?
 
R

Rick Brandt

I have a form containing a list box for which I do not want a default
value. I can not figure out how to make the list box "not have" a
default value. Can someone help?

If the DefaultValue property is blank in both the control on the form and
the field in the table then no Default should be getting applied.
 
A

Anne-Marie

both my table and form have no default value; but the form is still showing a
default value (which corresponds to the first record of my lookup table)
 
R

Rick Brandt

both my table and form have no default value; but the form is still
showing a default value (which corresponds to the first record of my
lookup table)

Are you sitting on the new record position? You only see the default
value on a new record. If you are opening your form to the first
(already existing) record then the ListBox will reflect the entry on that
record.
 
J

Jeff Boyce

Anne-Marie

Perhaps we don't share the same definition of "default value".

When I create a listbox, and populate it, it has values showing, but none is
selected until I highlight it/click on it/etc.

Are you saying that you can see a value in the listbox, or that the listbox
has a highlighted value in it?

Regards

Jeff Boyce
Microsoft Office/Access MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top