On Tue, 2 Mar 2004, Chris Alexander wrote: > What is the syntax to find a blank or null field in a table? Something along > the lines of 'is blank', 'is null', =" " (which doesn't return anything)...
If the field is a string, the test is ="" (no space between the quotes.) If it is a number, the best you can do is see if it's zero. Same with a logical. If you need to test an object, then use Str$(obj)="". - Bill Thoen --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 10677
