Do more with
=Iif(Len(Dir([YourDirectoryColumn], vbDirectory)), "Exists", "Nope")
Open in new window
=Len(Dir([YourDirectoryColumn], vbDirectory)) > 0
Note: The function, method, object, or property described in this topic is disabled if the Microsoft Jet Expression Service is running in sandbox mode, which prevents the evaluation of potentially unsafe expressions. For more information on sandbox mode, search for "sandbox mode" in Help.
IT issues often require a personalized solution. With Ask the Experts™, submit your questions to our certified professionals and receive unlimited, customized solutions that work for you.