blank option in combo box

[thread]

hi all,
i raised an issue that might seems to be stupid but every cosmetic is
critical.
i build a filters that basing the data from a table,now in the list of
the combo box you will see all the list from the table but there isnt
any option for <blank>,in excel of course that you have this option but
in access its probbly diffrent.
how can i give the option of <blank> when scrolling down the list in
combo box?

 

[Guest]

Hi

If you want to allow users to add to the list - set the Limit to List to No.

If you "really" want to see a blank space just add a semicolon at the start
of the list

;;1;2;3;4;5;6;7;8 etc

 

[Ron2006]

When someone is sitting in/on a combo box they can usually simply
delete anything that is showing and this will show the box as blank.

This is of course dependent on if the box is bound to a field and the
field allows null values.

Ron

 

[Robin]

I think others may be misunderstanding your question.

It seems to me that you want your combobox to display a list of values from
an underlying table, AND the words "(Blank)" and "(Non-blank)", in the same
way that Excel can filter for blank or non-blank cells.

Before we go any further, is this the right question?

 

[thread]

hi robin,
you understand me correctly this is what i'm trying to do,the non-blank
is not important becaouse it suppose to give a name anyway but the
option of <blank> is important when the user wants to loose the filter
of the specific combo box

 

[Robin]

Could you post the ControlSource property setting for your ComboBox.

 

[thread]

SELECT

.[field]
FROM

GROUP BY

.[field]
ORDER BY

.[field];

how can we add the option for clear textbox
Robin כתב: