Value list checkbox to formatted text field

[FMRusty]

Hi,

 

Field 1

Value list with editable check box

 

  cat

  dog

  mouse

  Other...

 

If I select just cat and mouse, I would like Field 2 to look like:

 

cat.  mouse.

 

Not sure whether this is a calculation or a script that I need to create, either way, not sure how I get it to select the line of text.

[doughemi]

Field2 = Substitute(Field1;"¶"; ". ")

[FMRusty]

Totally awesome, thank you.