Allow the "*" use in cbo box with number format

[L'apprentis]

Don't know if you noticed but I am kinda of struggling with my Cboboxex and my fields format...I am getting there but I find it a bit tricky just for something that seems so trivial.

I have the following cbo boxe bound to a number:

SELECT DISTINCT TblDrawing.SheetNo 
FROM TblDrawing 
UNION SELECT "*" FROM TblDrawing;

Because of the wild card character the Cbo box doesn't work as it should, the asterix has been added to allow me to have an option to see all my data.
Any ideas what I can do ???....

 

[L'apprentis]

Thanks for your reply,
I understand what you are saying, this is not an ideal situation as I wanted the user to be able to jump between specific data and "all" data viewing.
I will change the criteria as you suggested, though.