How to set default value in combo box (Access 2002)

Topic

New Reply

Hello again everyone! I need to set the default value of a combo box which is in a form to None. The combo box is linked to a table and one of the values in the table is None. However when i try to enter in None into the default value box under form desgin (combo box data properties) it does not default to none.

Thanks again.

Reply | Quote

Replies

If you enter None in the default value property, does Access change it to “None” (including the quotes)?

Reply | Quote

yes it does, however in the form itself it does not display it.

Reply | Quote

Just to make sure: you must save and close the form, then open it. Just switching from design view to form view is not enough to get the default value.

More questions:
– Is the form bound? I.e. is the Record Source property of the form non-empty?
– If so, is the combo box bound? I.e., is the Control Source of the combo box set to the name of a field in the Record Source of the form?

Reply | Quote

I am not sure if the form is bound.

The combo box is bound….

Reply | Quote

I did try saving closing the form and opening again, no luck. The combo box’s are bound to fields type-type10 inside there are many values one of which is None which has a price of 0.00, every other one is a window blind size ie 102 x 66 and a price $.00 the price field is what i stored into the database for future use, could this be the problem?

Reply | Quote

If the price field is the bound field, you should set the default value to a price; the combo box will automatically display the corresponding item.

Reply | Quote

Hans, you have absolutely no idea you’ve helped me! THANK YOU SO MUCH! I have been working on this problem since noon. Its now 4:15, I am disgusted that it was such a simple problem. Thank you so much!

Thank you!

Reply | Quote

Hans, you have absolutely no idea you’ve helped me! THANK YOU SO MUCH! I have been working on this problem since noon. Its now 4:15, I am disgusted that it was such a simple problem. Thank you so much!

Thank you!

Reply | Quote

If the price field is the bound field, you should set the default value to a price; the combo box will automatically display the corresponding item.

Reply | Quote

I did try saving closing the form and opening again, no luck. The combo box’s are bound to fields type-type10 inside there are many values one of which is None which has a price of 0.00, every other one is a window blind size ie 102 x 66 and a price $.00 the price field is what i stored into the database for future use, could this be the problem?

Reply | Quote

I am not sure if the form is bound.

The combo box is bound….

Reply | Quote

Just to make sure: you must save and close the form, then open it. Just switching from design view to form view is not enough to get the default value.

More questions:
– Is the form bound? I.e. is the Record Source property of the form non-empty?
– If so, is the combo box bound? I.e., is the Control Source of the combo box set to the name of a field in the Record Source of the form?

Reply | Quote

yes it does, however in the form itself it does not display it.

Reply | Quote

If you enter None in the default value property, does Access change it to “None” (including the quotes)?

Reply | Quote