By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,462 Members | 2,360 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,462 IT Pros & Developers. It's quick & easy.

How to return multiple strings from a user defined function

P: n/a
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.

May 8 '06 #1
Share this Question
Share on Google+
1 Reply


P: n/a
String Variables can be longer than 255 characters.

It is Text Fields that have a maximum of 255; but, if you want to store
these values, just use a Memo Field instead. You can type a max of 65,536
characters in a Memo field, but storing data via program, you can store even
more.

So, perhaps you don't have the problem you anticipated.

Larry Linson
Microsoft Access MVP
<co******************@yahoo.com.au> wrote in message
news:11*********************@e56g2000cwe.googlegro ups.com...
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.

May 8 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.