Solved Combos set up with a 'Value List' : the 'Row Source' ellipses have disappeared !?

[alan2013]

Must say I've never seen this happen before, but :

I've a combo box set up with a Value List ('Row Soiurce Type : 'Value List') on a Form, and until today it was working well; no problems.

Today, for some unknown reason, the 'Row Source' ellipsis has disappeared. ('Data' tab > 'Row Source'). I'd just wanted to add an option to the combo. I'd tried to get the ellipsis back by 1) closing the Form and going back into it; closing the database and reopening; restarting my PC.

I now see that the ellipses on other combos on other Forms have ALSO disappeared.

Anyone know what the problem might be, please ? More of a graphics driver problem than anything else ?

 

[bob fitz]

I have no idea why the ellipsis should disappear but you can always edit the list by editing the Row Source property.

 

[alan2013]

I have no idea why the ellipsis should disappear but you can always edit the list by editing the Row Source property.

Yeh, I meant to say in my post :
When I try to add an option simply by typing it in, it still doesn't appear in the list of options presented by the combo.

 

[theDBguy]

Have you tried doing a C&R? Just curious...

 

[MajP]

Can you post a screen shot. As stated that is normal behavior. A value list will not have any elipsis. You add by typing in a value preceded by ;

Today, for some unknown reason, the 'Row Source' ellipsis has disappeared. ('Data' tab > 'Row Source'). I'd just wanted to add an option to the combo. I'd tried to get the ellipsis back by 1) closing the Form and going back into it; closing the database and reopening; restarting my PC

to add "frog"
dog;cat;mouse;frog

 

[CJ_London]

assuming the ellipsis problem is resolved (they don't appear for value lists), turning to

When I try to add an option simply by typing it in, it still doesn't appear in the list of options presented by the combo.

typing it in where? the rowsource? or by editing the combo? (i.e. the limit to list property is set to no)





i

 

[bob fitz]

A value list will not have any elipsis.

I have them once the focus is on the Row Source property.

 

[MajP]

I got it now. The ellipsis appear if you have the property "Allow Value List Edits" set to true. I personnally would NEVER do this so that is why I did not see the ellipsis.

 

[MajP]

Also I know why you cannot add anything. @isladogs demos this in a challenge.

Combobox Zombies Puzzle

Here's a little puzzle for anyone interested. It is based on a similar item posted at the DBGuy's website 3 years ago which he was unable to explain. As I like riddles(!) I worked out how it was done and am posting a modified version here with his permission. The attached database contains...

www.access-programmers.co.uk

Two of the dumbest features in access are Allow Value List Edits and "Inherit Value List". In his challenge I think he demos this problem. If you have a value list at the table level and you inherit it, you can not modify it at the form level.

 

[alan2013]

Thanks to everyone..

 

[gemma-the-husky]

Even when I have a value list, I tend to set it in code. Let's say I want a value list consisting of the last 5 years, so 2022 down to 2017. I create a row source string with those values, when the form opens. Next year it automatically becomes 2023 to 2018.