Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #3  
Old 11-13-2020, 02:27 PM
evilside evilside is offline Test Field Contents Windows 10 Test Field Contents Office 2016
Novice
Test Field Contents
 
Join Date: Nov 2020
Posts: 3
evilside is on a distinguished road
Default

Quote:
Originally Posted by macropod View Post
The behaviour is by design - each '?' represent exactly one character, but the '*' represents any number of characters. The question is why are you using such a construction to test whether a field is empty, when that should be done with code like:
Field is {IF{REF textFormFieldName}<> " " "not "}empty
A field that contains at least six characters cannot be empty...

Easy, because:


{IF{REF textFormFieldName}<> "" "not "}


...not working. That is the origin of this thread. This trick was useful in my case.
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Student's t-test (T.TEST): how to get p value? seanspotatobusiness Excel 1 07-20-2018 05:46 AM
Test Field Contents Include Table of Contents by Mail Merge Field vandelayindies Mail Merge 1 01-08-2018 03:06 PM
Contents Page Field Formatting hdmackay Word 17 01-12-2017 01:44 PM
Test Field Contents Table of contents not displaying custom text in field wrdy Word 3 01-05-2015 02:57 AM
unable to send test message Please verify the email address field jarv Outlook 0 04-30-2010 07:15 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 04:59 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft