Using comments in formulas?

[wookie]

Does anyone know a trick how to add comments to formulas?

I have some pretty complicated and long formulas which I would love to comment here and there, just in case I have re-adjust them at any later time.

[color:"#666666"](Please don't recommend to use sub-formulas - this databases already has 180 fields and I don't want to create even more)

[Lee Smith]

Hi Wookie

This came up on another list and here are some of the suggestions that came out of it.

1. External("Comment", " Your comment here " )

2. Number type: + Case("this is a comment" = 0, 0, 0)

3. Text type: & Left("this is a comment", 0)

4. If(0, "This is where I type my comment about the calculation formula", calc formula goes here...)

HTH

Lee

[Chuck]

Use the left function, as in:

Left( "Your comment here", 0 ) & TheRestOfYourCalc'sFormula

This will work if your calc's result is text. Use something like:

Length( Left( "Your comment here", 0 ) ) + RestOfCalc

If the result is date, time or number.

Chuck

[wookie]

Thanks for the rapid response!