Simple MS Access Help

TrevorK

Senior member
Oct 11, 2000
491
0
0
OK guys, quick question for Access (I'm sure you VB guys would be able to answer this one).

I have a form, which has some list boxes. The only purpose of the list boxes is to show 4 items (Like Employee Status let's say), and is populated through a query. My problem is, when the form loads, the list boxes contain the 4 items in them. It's really annoying to see a disabled listbox actually have something in it (Like a text box that has something in it when disabled. Just plain stupid). What could I do to get the listbox to display NOTHING until the user selects something?

Trevor
 

jobert

Senior member
Nov 20, 1999
714
0
0
How can the user select an item from
the list box if there is nothing in it?

Do you mean that the list box shows the first
item before the user clicks on it to make it
drop down? If this is the case, make your first
list item "Select Status" or something like that,
AND check that that item is NOT put into the record
before you save it.