In this video, I have attempted to get Blanks checkbox to work and using the exact code in the video, that portion of the code will not show the blanks. Very puzzling. The Exact works fine and I have concatenated the "" to each of the columns to convert nulls to empty strings but the iif code simply doesn't work.
Hi Michael. This is one of those things that is impossible to help you with unless I can see what you're doing. All I can say is that the example in the video works. Hundreds of students have taken this class, and nobody else had this problem. Double-check your spelling. Retrace your steps.
Michael KrailoOP
@Reply 6 years ago
I can only assume that this was the form not getting refreshed properly. After I posted this and went to bed, I woke up and tried it again only to see it all working! Sometimes Access can be annoying in that way. So everything is working now.
Yeah, rebooting your PC is usually one of the first things I recommend. You've inspired me to start the Access Troubleshooting Checklist! I've been meaning to do this for a while now.
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Access Search Seminar.
