Hack Posted February 22, 2006 Posted February 22, 2006 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 -]
Lee Smith Posted February 22, 2006 Posted February 22, 2006 A return means a new line? wouldn't that be expected behavior? Or did I miss read your question. Lee
Hack Posted February 22, 2006 Author Posted February 22, 2006 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
Lee Smith Posted February 22, 2006 Posted February 22, 2006 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
Hack Posted February 22, 2006 Author Posted February 22, 2006 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 -]
Lee Smith Posted February 22, 2006 Posted February 22, 2006 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
Hack Posted February 22, 2006 Author Posted February 22, 2006 Hay thanks lee thats great help, I think I will leave the parse out the names etc to another day thanks again Cheer Hacky
Recommended Posts
This topic is 6882 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now