Leaderboard

If you cannot rely on users to enter a negative amount for expenses then let them enter a positive amount for both and use a calculation field along the lines of: If ( Type = "expense" ; -EnteredAmount ; EnteredAmount )

Uh-oh...

Is your field formatted to show a scroll bar?

See the attached demo. A few notes: The script here is triggered on object exit. The default height is hard-coded into the script. The default height was measured using GetLayoutObjectAttribute() when the field is empty and active. This is different from the height dimension shown in Layout mode. This simple implementation has a flaw: if you edit an overflowing field and shorten the text so that it no longer overflows, the script will still mark it as overflowing. That's because the field only expands as you type, not shrink as you delete. To get the correct result, you would need to re-enter and re-exit the field. MeasureOverflow.fmp12