Newbies gregtell Posted September 10, 2006 Newbies Share Posted September 10, 2006 Is there a way to display only the checked boxes in a field? I have a field that may have ten items that could be checked but I only want to display and print out the items that have been checked. It could be zero to all of them checked. Link to comment Share on other sites More sharing options...
Lee Smith Posted September 10, 2006 Share Posted September 10, 2006 Checkboxes are just a way of seeing the data in a field. What you need to do is to look at the data in a regular field. You can either put this on a separate layout, or on the same one. Do a search of the Forum on Checkbox Display, and you might find more information on this subject. HTH Lee Link to comment Share on other sites More sharing options...
LaRetta Posted September 10, 2006 Share Posted September 10, 2006 Hi gregtell, welcome to FM Forums! As Lee says, you can place the regular field on your layout. Values in a checkbox display as multiline thus: Item1 Item6 Item9 Right-click field and set Field Control Setup as Edit Box. Then you can set the field to Format > Set Sliding/Printing (if need be). Make the field as large as you need then apply Slide Left and/or Slide Up. If you want this list as one line separated by commas then you need to create a calculation (text, unstored) and display that on your printout with: Substitute ( ValueListItems ( Get ( FileName ) ; "yourVLname" ) ; ¶ ; ", " ) LaRetta :wink2: Link to comment Share on other sites More sharing options...
Ender Posted September 10, 2006 Share Posted September 10, 2006 If you want checkboxes on the checked items (but only the checked items), you can add a self-join TO on the record ID, define a value list based on the related original field, and apply that value list as a checkbox set to the field on the print layout. Link to comment Share on other sites More sharing options...
Newbies gregtell Posted September 10, 2006 Author Newbies Share Posted September 10, 2006 LaRetta, Thanks for you help. But I don't understand what you mean by: "If you want this list as one line separated by commas then you need to create a calculation (text, unstored) and display that on your printout with: Substitute ( ValueListItems ( Get ( FileName ) ; "yourVLname" ) ; ¶ ; ", " )." I have a database named Menu and a checkbox field named Items with several checkbox items and I would like the checked items only displayed on a single line seperated by either comas or spaces. Could you explain in a little more detail the above function? What is a calculaton (text, unstored) ? I hope I am not asking for too much? Link to comment Share on other sites More sharing options...
LaRetta Posted September 10, 2006 Share Posted September 10, 2006 When you attached your checkbox value list to your Items field, it meant that you have created a Value List. I assume it's called Items? Look and make sure of the exact name - you'll need it for the next step. Now open your Define > Database > Fields tab and create a new field called cItemsLine. The TYPE of field will be calculation. When the calc box opens, you will put this in the calc box: Substitute ( ValueListItems ( Get ( FileName ) ; "Items" ) ; ¶ ; ", " ) Change the result type (bottom left popup) to be TEXT. Then select Storage Options and click 'Do Not Store Calculation Results...' Say OK, then OK to back out of the calc box, then OK at your Define Database to save your new calc. Then add the new calc to your layout. It will display only chosen values as Value1, Value6, Value9 in a one-line display. And no, you aren't asking too much. We expect people to come to Forums and ask questions. I ask many questions also. :smile2: Link to comment Share on other sites More sharing options...
LaRetta Posted September 10, 2006 Share Posted September 10, 2006 Oh! But as Mike indicates, if you want the Value List to only contain entries for each record, you will need to establish a join (uniqueID = uniqueID) and base your value list on 'Use Values from Field' and only related (this self-join) values. Link to comment Share on other sites More sharing options...
comment Posted September 10, 2006 Share Posted September 10, 2006 Perhaps I am missing something, but it seems to me that a calculation field (result is Text) = Substitute ( Items ; ¶ ; ", " ) should do the job of "checked items only displayed on a single line seperated by either comas or spaces". Unless the checked items need to be sorted by their order in the value list (otherwise they will show in the order of their selection). Link to comment Share on other sites More sharing options...
LaRetta Posted September 10, 2006 Share Posted September 10, 2006 I suppose you could do it the easy way. ;-) Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 6566 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