I have a series of fields (FM8A, Win XP) with similar names (FullName1, FullName2, etc.), and I need to clear/set all of them in a script. I can do this, of course, by specifying each field individually and the set or clear operation to be performed.

Since the names are identical except for the numerical designator at the end, how can I set up a loop to do this more simply?

Thanks!

James McAlister

www.BulletinInserts.org

www.james-mc.com

There's not a dynamic way to set the target field. Instead you can put all the fields on a layout and loop through them using Go to Next Field to change the target. Loop through that as many times as there are fields.

This sounds like a good place for a related table, instead of "FullName1, FullName2, etc.".

I was hoping to be able to use something like the FieldNames function to return a list of fields, loop through them testing for field names that match the pattern, and then act on those fields as required. But I guess that will have to wait until field names can be specified dynamically. :

I'll look at the layout approach, though. Thanks!