I have built a database for dog pedigrees.
I want to be able to display the siblings for a dog on it's pedigree. I
am able to find the names in my database, and at present return them
from a UDF concatenated into one long string.
Problem is a large litter can exceed 255 characters of a string.
I thing a better solution is to assign the dogs names to an array of
strings and return that from the UDF as type variant.
My problem now is, how do I take the data from the array, and place
them on a report. Currently I use a bound textbox and its data source
is the UDF.
What type of control can display an array of strings returned as type
variant?
Thanks.