UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
3 Pages V < 1 2 3  (Go to first unread post)
   Reply to this topicStart new topic
> Dlooup Theory, Access 2010    
 
   
theDBguy
post Feb 1 2017, 11:49 AM
Post#41


Access Wiki and Forums Moderator
Posts: 69,964
Joined: 19-June 07
From: SunnySandyEggo


You could try:

Expression Is: [contact name] Is Null

or

Expression Is: IsNull([contact name])

or

Expression Is: [TextboxName] Like "*vacant - *"

Hope it helps...

--------------------
Go to the top of the page
 
MrWrap2
post Feb 1 2017, 03:31 PM
Post#42



Posts: 78
Joined: 10-January 17



after all the help you've provided theDBguy, im going to owe you a few cases of beer! thanks for the help!

CODE
Expression Is: [TextBoxName] Like "*vacant - *"
worked!
Go to the top of the page
 
theDBguy
post Feb 1 2017, 03:58 PM
Post#43


Access Wiki and Forums Moderator
Posts: 69,964
Joined: 19-June 07
From: SunnySandyEggo


Hi,

You're welcome! We're happy to assist.

But a cold one is also appreciated!

Cheers! cheers.gif

--------------------
Go to the top of the page
 
3 Pages V < 1 2 3


Custom Search
RSSSearch   Top   Lo-Fi    27th June 2017 - 05:19 AM