help with a Debit / Credit for a checking Acct form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

good day all,

I have a frm that I use for viewing and reconciling checking account data.

I have my Debit & Credit fields. Right now for a debit I have to enter
-500.00. I was wondering if there was a way that I could just enter the
number and based on the Debit field, would recognize it as a negative?

Any suggestions?

thanks,

Brook
 
In the fields Before_Update event try something like

If Me.fieldName > 0 then Me.FieldName = Me.FieldName * -1
 
Thanks for the post,

I just tried it and am getting a Debug error on the code after the "then"
clause..

Brook
 
Can you post the actual code. It should be fine.
Thanks for the post,

I just tried it and am getting a Debug error on the code after the "then"
clause..

Brook

:
Click to expand...
 
Hello David,

Here is the code that I used:

If Me.Debit > 0 Then Me.Debit = Me.Debit * -1


Brook
David C. Holley said:
Can you post the actual code. It should be fine.
Click to expand...

he code after the "then"
 
Back
Top