If ComBox = "Debit" Then Value Entered is Automatically Negative

[Tuckejam]

I have a form for entering Transactions into an account ledger.



so when I select Transaction Type "Debit" from the Combobox I would like the value entered in the Amount field to automatically be a negative value


Thank you

[Bob Fitz]

Try:
If combox = "Debit" Then
AmountField = -1 * AmountField
End If

[CJ_London]

or just

If combox = "Debit" Then
AmountField = -AmountField
End If

or just leave it as a positive and apply the negative as and when required

[ArviLaanemets]

Have combo's (e.g. cbbTransactionType) RowSource = '1;"debet";-1;"credit"', LinkedColumn = 1, ColumnCount =2, ColumnWidths = "0,2.5" and BoundColumn = 1. Then

...
Me.txtAmountField = ABS(Me.txtAmountField)*Me.cbbTransactionType
...