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

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

=-=-=-=-=-=-=-=-=-=-=-=-=

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

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.