Hi,

I have a database where we want users to select search criteria using checkboxes but to have those "checked" results displayed as a comma delimited string when browsing records. Seems to me that the older versions of FM used to store checked results as comma separated strings. Now that I'm using version 7 I see the checked results all show on a separate line in the field (When simply dragging the field to a new layout for browsing records). So the items are separated by vertical tabs. Am I crazy or did older versions use commas?

Anyway, what to do ... Is there a setting somewhere for changing the delimiter between checked items? Or should I duplicate the field and write a calculation to convert the checked items from lines to comma sperated entries? (I could use a hint for that if that's the route I should take).

TIA,

Use a calculation field of Substitute( textfield, "

Deja vu?

Yes, all over again.