Filter combo box shows only Is Null / Not Is Null

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Tony - 20 Mar 2006 18:19 GMT

Hi,

I wonder why when I do a filter by form, some text fields show all the
data in the table in the combo box and others only show two items, Is
Null and Not Is Null. I want to show all data, instead of just null or
not null. I created the text fields the same way. But I don't know if I
have changed some properties since and not realized.

Thanks,
Tony

Reply to this Message

wkalo - 20 Mar 2006 20:44 GMT

Hi There
Can You Attach Sample So I Can Review It

--
wkal

Reply to this Message

Tony - 21 Mar 2006 16:45 GMT

wkalo,

Thanks for your response. I found out that if the Filter Lookup
property of the form text field is set as Database Default, then after
a certain number of items, it will display Is Null and Not Is Null. If
Filter Lookup is set as Always then it will display all the data. Well,
since my data is growing pretty big so I guess I have to live with Is
Null and Not Is Null.

Thanks again.
Tony

Reply to this Message

wkalo - 21 Mar 2006 20:45 GMT

Good luck!

--
wkal

Reply to this Message