February 22, 200619 yr Hi I am have some trouble with data spilting in Pop-up Menu. The is data from an Define value list. (second screen dump show source ). If I enter the text in the source field and put return at the end text line and start a new line it spilt the data in the Pop-up menu but if there is no return in the field and text just Continues on and there is no spilt of the text on the pop-up menu. I hope some one can help me with this regards hacky -]
February 22, 200619 yr A return means a new line? wouldn't that be expected behavior? Or did I miss read your question. Lee
February 22, 200619 yr Author Hi Thanks for getting back to me What I trying to do with the data from the pop-up menu is to display a postal address. So the text needs to be displayed with (returns) i.e multable lines from the same Field. Is there some formating I can do at the source Field to change this? thanks again Hacky
February 22, 200619 yr If I'm understanding you correctly, what you are wanting is a conditional value list. Since you mentioned Postal, check out the Zip Code sample file posted in Sample Files Topic area, I think this is what you are after. Anyway, multiple lines in a value list is a new one to me. Lee
February 22, 200619 yr Author Hi Lee thanks for help I had look at the zip code sample will have look at developing it may be I also should break down my address into different field so it display properly when printed i.e. as an list rather than having them all in the last field Company name (other source field) street address postal address Town or Suburb City Country other Cheers Hacky -]
February 22, 200619 yr Absolutely. You will find that the more you break your data down, the more you can manipulate it when needed. For instance, contact Name_First Name_MI Name_Last Prefix (i.e Dr. Mrs. Mr. etc.) Suffix (i.e. Jr. Sr. etc. ) Street_Add Mail_Add, When needed, use a calculation field to put them together as you want. i.e. Name_Last & ", " & Name_first I forgot to mention that if you left your data as it is now, the next thing you would be asking us is how do I parse out the names, address, etc. into separate fields. HTH Lee
February 22, 200619 yr Author Hay thanks lee thats great help, I think I will leave the parse out the names etc to another day thanks again Cheer Hacky
Create an account or sign in to comment