I have a value list that holds product spec via a checkbox set which is working fine. I would now like to use this data in a layout I have created for printing purposes. I would like to add a (different colour) bullet point next to each

value in the list.

Is there a way to do this?

I'm not sure that this can be done but I am asking anyway just in case!

thanks

Assuming you mean you want to print the actual specs (and not the value list itself), you could define a calculation field =

"• " & Substitute ( Specs ; ¶ ; "¶• " )

I'm not sure what you mean by "different colour". You can color the bullet separately from the text by:

Let (

bullet = TextColor ( "• " ; RGB ( 51 ; 153 ; 255 ) )

;

bullet & Substitute ( Specs ; ¶ ; ¶ & bullet )

)

thanks , I shall try that

Thanks, that's exactly what I wanted...

but, on some of the product records there is a bullet point at the bottom of the list on its own (no spec next to it) although no spec is missing.

The field that holds the spec has auto calc on it

FilterValues ( ValueListItems (Get (FileName); "phone_spec") ; Self )

which makes sure even if the user ticks the options in non sequential order it sorts them

(I'm pretty sure Comment helped with this)

Could this cause the problem,

thanks again

Edited September 9, 200817 yr by Guest

on some of the product records there is a bullet point at the bottom

Some or all? FilterValues(), like all …Values functions, always leaves a trailing carriage return. This can be handled by modifying the last part to:

...

bullet & Substitute ( Specs & ¶ ; [ "¶¶" ; "" ] ; [ ¶ ; ¶ & bullet ] )

)

To answer your question - some.

I've tried what you suggested and...

strange, all the records that had the extra bullet point are corrected and the ones that didn't now have one

It seems that if I now delete the spec from each record and re-enter it the problem is corrected

Edited September 9, 200817 yr by Guest

It's not strange at all - the formula expects uniform input. You probably added the auto-enter feature after some records were already in place. These records remain unaffected until modified.

Possible solutions:

1. Replace the Spec field's contents with itself (careful, there's no undo - have a backup!);

2. Remove the auto-enter and do the sorting in the same formula that adds the bullets (assuming you don't need the sorted result elsewhere);

3. Change the formula to:

...

bullet & Substitute ( LeftValues ( Specs ; ValueCount ( Specs ) ) & ¶ ; [ "¶¶" ; "" ] ; [ ¶ ; ¶ & bullet ] )