In my data base I use quite a few drop down lists to save time in typing. There are several places where I have to go back in and hit enter to create proper paragraph separations.

My question is can I put a carriage return in the line of text that will allow for the appropriate spaces in my text box?

What about an auto-enter value for the field that has the value list ?

Something like:

Case(

ValueCount ( FilterValues ( Self ; "YourValuesThatNeedCarriageReturn" ) ) ; Self & ¶ ;

Self

)

The carriage returns needed are typically in the middle of a line of text and typically require multiple returns. The reason I use the carriage returns is to allow for ease of reading by the reader. Let me give example.

The text that drops down looks like this:

Pool has algae. Clean, check and balance pool. Treat algae. Check over all.

So I go back in and separate the lines to make the text easier to read like this:

Pool has algae.

Clean check and balance Pool.

Treat Algae.

Check over all.

There are many different lines of text I can select, so one case does not necessarily meet all the criteria. So I wanted to see if there was a text based carriage return trigger. For example

Pool has algae.¶¶¶ Clean, check and balance pool.¶¶¶ Treat algae.¶¶¶ Check over all.

If the 3 carriage returns are always after a fullstop:

Substitute ( Self ; ". " ; "¶¶¶" )

See the attached file for another approach.

The carriage returns needed are typically in the middle of a line of text and typically require multiple returns.

Multiple returns are neither required nor desired - format the field's paragraph spacing instead.

Values.zip