Value List default value

[arm1]

I was hoping someone could assist:

I open a form which accesses a table record.

I have a field which is a drop down list that is a Value list with the values Yes;No.

When this form opens and the record is displayed, the value that shows up in this drop-down field is (for example) "No". This is the case, despite the record not yet having a value entered for this field. When I create the record, only the primary key fields are assigned values... the remaining fields are left Null until the user enters a value.

Is there a way of having a Value List and NOT have anything displayed by default?

I have tried setting the DefaultValue property to Null... doesn't work.
I have tried adding a Null to the list of value options and setting IT as the default... it doesn't seem to work.

Any idea how I can have a list, but keep the field value BLANK until the user explicitly selects one of the list options?!?

Thank you for you help,

- arm1

 

[Kay Davies]

Hello

I am not sure why your field is doing this but I will try to suggest a solution. You don't say how you are assigning the value list but I find the easiest way is to simply create a new table with a single field which contains the values you want in your list eg yes and no. Then go to the properties of the box in the form you want to assign the list to and in row source type click 'table/query' and in the row source click on the table that has the values to appear in your drop down list.

I hope this makes sense and I hope it works - it always does for me.

regards
Kay

 

[arm1]

I understand the proposal... but there are a few glitches.

Sometimes I have drop down lists that are Yes / No

Sometimes its is Yes, No, Maybe.
Sometimes it is Yes, No, Sometimes, Never
etc...

The point is that I couldn't be creating a new table every time I need a variation of a drop down list.

In my case... I create my lists as follows:

The field has the following properties:

1) Format = Yes/No
2) Row Source Type = Value List
3) Row Source = Yes;No
4) Default Value = <left blank>
5) Limit To List = No

I have tried setting the Default Value to Null... but it changes nothing.

I am really not sure why any of the drop-down list options are already selected... which is why I can't quite figure out how to make the blank entry the default.

Thanks for your help,

- arm1

 

[boblarson]

I understand the proposal... but there are a few glitches.

Sometimes I have drop down lists that are Yes / No

Sometimes its is Yes, No, Maybe.
Sometimes it is Yes, No, Sometimes, Never
etc...

The point is that I couldn't be creating a new table every time I need a variation of a drop down list.

You don't have to create a table for each. Create ONE table and then do this:

Make sure to have a field like "NamedUse" as the name (text) and then name it like YesNo, YesNoSN, or something like that. Then you use a query for your rowsource for the combo you can get the values you need.

See the attached sample - it uses one table for all of the values for each combo.