Wildcard variable for fields in macro condition

[mulligh]

I have fields named size1 size2 size3 ... through size20. I want to create a condition in a macro that checks to see if size1 - size20 fields are null. Is there a way to refer to all 20 fields in one statement (other than OR-ing them together )

Thanks for the help.

 

[joebickley]

hi m8

you will struggle to do this easiley in a macro cos they are not really disigned to do anything complicated.

Your best bet would be to convert the macro into a VB module (this is easy look at the helP) and then use the VB code to cycle through each of the fields to check for nulls

In the vb code you will need to create an array of the fields which is basically a virtual list and then use a for loop to cycle through each line.

if you need help with doing this let me know and i will see what i can do

thx
joe