Is this possible

[myxmaster]

I have a combo box with 2 choices , withdrawal or deposit. I then have
a field called amount. If the user selects deposit and then enters say
$1000 in the amount field, is it possible to make the default entry a
negative number ($-1000). I know I can have the user enter the number
as a negative however if they forget the minus key then the amount
will reflect as a positive number.

TIA

 

[fredg]

I have a combo box with 2 choices , withdrawal or deposit. I then have
a field called amount. If the user selects deposit and then enters say
$1000 in the amount field, is it possible to make the default entry a
negative number ($-1000). I know I can have the user enter the number
as a negative however if they forget the minus key then the amount
will reflect as a positive number.

TIA

Don't you also wish to assure that any Withdrawal is a positive
number?

Code the Amount control's AfterUpdate event:
If IsNull([ComboName]) Then
MsgBox "You Must select either Withdrawal or Deposit."
Exit sub
If Me.[ComboName] = "Deposit" Then
If Me.[Amount] >0 Then
Me.[Amount] = Me.[Amount] * -1
End If
Else
If Me.[Amount] < 0 Then
Me.[Amount] = Abs(Me.[Amount])
End If
End If
End If

 

[Aaron Kempf]

yeah.. with SQL Server you can have RULES that apply to a particular
datatype

so that if you want to reuse a particular constraint (such as money greater
than 0) you can define it once and use it in 100 different places

the concept is called 'code reuse'
and it's not possible with MDB

I have a combo box with 2 choices , withdrawal or deposit. I then have
a field called amount. If the user selects deposit and then enters say
$1000 in the amount field, is it possible to make the default entry a
negative number ($-1000). I know I can have the user enter the number
as a negative however if they forget the minus key then the amount
will reflect as a positive number.

TIA

Don't you also wish to assure that any Withdrawal is a positive
number?

Code the Amount control's AfterUpdate event:
If IsNull([ComboName]) Then
MsgBox "You Must select either Withdrawal or Deposit."
Exit sub
If Me.[ComboName] = "Deposit" Then
If Me.[Amount] >0 Then
Me.[Amount] = Me.[Amount] * -1
End If
Else
If Me.[Amount] < 0 Then
Me.[Amount] = Abs(Me.[Amount])
End If
End If
End If

 

[myxmaster]

I have a combo box with 2 choices , withdrawal or deposit. I then have
a field called amount. If the user selects deposit and then enters say
$1000 in the amount field, is it possible to make the default entry a
negative number ($-1000). I know I can have the user enter the number
as a negative however if they forget the minus key then the amount
will reflect as a positive number.

TIA

Don't you also wish to assure that any Withdrawal is a positive
number?

Code the Amount control's AfterUpdate event:
If IsNull([ComboName]) Then
MsgBox "You Must select either Withdrawal or Deposit."
Exit sub
If Me.[ComboName] = "Deposit" Then
If Me.[Amount] >0 Then
Me.[Amount] = Me.[Amount] * -1
End If
Else
If Me.[Amount] < 0 Then
Me.[Amount] = Abs(Me.[Amount])
End If
End If
End If

Hi Fred,
I pasted the code into the amount field and referenced the combobox
name (TransactionType) however when I select withdrawal or deposit
each amount is still reflected as a positive number. Any Ideas.

 

[fredg]

I have a combo box with 2 choices , withdrawal or deposit. I then have
a field called amount. If the user selects deposit and then enters say
$1000 in the amount field, is it possible to make the default entry a
negative number ($-1000). I know I can have the user enter the number
as a negative however if they forget the minus key then the amount
will reflect as a positive number.

TIA

Don't you also wish to assure that any Withdrawal is a positive
number?

Code the Amount control's AfterUpdate event:
If IsNull([ComboName]) Then
MsgBox "You Must select either Withdrawal or Deposit."
Exit sub
If Me.[ComboName] = "Deposit" Then
If Me.[Amount] >0 Then
Me.[Amount] = Me.[Amount] * -1
End If
Else
If Me.[Amount] < 0 Then
Me.[Amount] = Abs(Me.[Amount])
End If
End If
End If

Hi Fred,
I pasted the code into the amount field and referenced the combobox
name (TransactionType) however when I select withdrawal or deposit
each amount is still reflected as a positive number. Any Ideas.

Sorry, my goof.
An End If was in the wrong position.

Paste this into the [Transaction Type] AfterUpdate event.

If IsNull([Transaction Type]) Then
MsgBox "You Must select either Withdrawal or Deposit."
Exit sub
End If
If Me.[Transaction Type] = "Deposit" Then
If Me.[Amount] >0 Then
Me.[Amount] = Me.[Amount] * -1
End If
Else
If Me.[Amount] < 0 Then
Me.[Amount] = Abs(Me.[Amount])
End If
End If