Newbies leeej Posted October 24, 2000 Newbies Share Posted October 24, 2000 I am designing a database. I am using multiple layouts and placing fields from one layout into another. My problem is that I created a checkbox value list in one layout. The information checked is "supposed" to appear in another layout(table format) as a single line of information containing only those values that were checked. I can't get it to work!! The info will appear, but it is listed in the field as one value per line (which is impossible to deal with in a one lined table). Is there any way I can format the second field to present the data consecutively? THANK YOU Link to comment Share on other sites More sharing options...
Kurt Knippel Posted October 24, 2000 Share Posted October 24, 2000 quote: Originally posted by leeej: I am designing a database. I am using multiple layouts and placing fields from one layout into another. My problem is that I created a checkbox value list in one layout. The information checked is "supposed" to appear in another layout(table format) as a single line of information containing only those values that were checked. I can't get it to work!! The info will appear, but it is listed in the field as one value per line (which is impossible to deal with in a one lined table). Is there any way I can format the second field to present the data consecutively? THANK YOU A checkbox formatted field, contains the items checked each on a seperate line. This is the way a checkbox field works. You will need to create a display calculation which Substitutes the paragraph return for a space or whatever delimiter you want. ------------------ =-=-=-=-=-=-=-=-=-=-=-=-= Kurt Knippel Consultant Database Resources mailto:[email protected] http://www.database-resources.com =-=-=-=-=-=-=-=-=-=-=-=-= Link to comment Share on other sites More sharing options...
Newbies leeej Posted October 25, 2000 Author Newbies Share Posted October 25, 2000 Thank you very much for your help.... I have been trying to figure out a way to use the calculation method to solve my problem. Could someone give me an example? Thank you in advance Link to comment Share on other sites More sharing options...
Vaughan Posted November 10, 2000 Share Posted November 10, 2000 This calculation will insert a comma and space between each of the values... Substitute[textfield, "P", ", "] ...where P should be the back-to-front paragraph symbol, and it should be in quotes because it is literal text. Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 8578 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