Debit and credit formats
Hello all,
I have a budget database.
There is an Expense field in which I have to input minus in front of the amount for debit. The thing is I would like this minus (for debits) to appear automatically whenever I type in an amount BUT not if I type a plus sign in front of the amount (credits).
Ex.
100⬠--> -100⬠(for debit)
+100 --> 100⬠(for credit)
The field is of currency type.
Thanks in advance,
Sven
|