Don't know if you ever found a solution, but since this problem has baffled us for a while the following articles did assist in alleviating/removing the dialog completely.
http://www.outlookpower.com/issues/issue200402/00001228001.html...
When using the formula I receive an error:
"String length is less than 0 or not an integer" and it highlights: left(MyLookupArray[y],instr(MyLookupArray[y]," ")-1)
I think my problem exists with how the data is entered in the custname field. I should have included earlier...
Hope this help clear what I am trying to do. I have a database with 2 tables. Custname and state. The users can enter as many names as they like in the custname field, separated by commas and assign a state to the custname field. I have a formula for custname that is supposed to search the...
Crystal newbie needs assistance. I have a field example customer name that may contain from 0-9 names. I have a formula that contains all the customer names which total about 50. The customer name also has a state assigned to it. I need the formula to extract each name and assign the state...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.