Custom field Lists

[BobWidomski]

I am trying to populate a list box on a custom form with the values of a
custom text1 field.

I used the CustomFieldValueListGetItem function successfully however I am
having trouble trying to determine the count of items in the custom field. I
have hard coded the count but would like have vba get the count for me.

thanks bob

 

[Rod Gill]

There doesn't seem to be a count property, so try looping and testing for an
error which would indicate end of list reached.

 

[BobWidomski]

Thanks, that worked. I didn't think of trapping the error.
Bob