I have a search form for my database that is great except for one thing...if one of my criteria on the table or query is null, my search will not retrieve that record. I can't seem to find a fix for the search query, BUT I thought of a way around it...the only thing is that I don't know how to do it, which is where you experts come in...there HAS to be a simple line of code that will autofill a field with any character...a period, dash, whatever...as long as there is something in the field, my search will work...can you help? THANK YOU!