Negative Number Help Needed ?

[Dave Elliott]

777 is a negative number for the criteria needed
That is it is lower than zero, i.e. ($2.00)
777 is a TextBox and on the main form.
So, if the value of the textbox 777 is less than zero the run code


If 777 < 0 Then
CI30.Visible = True
End If

 

[Dirk Goldgar]

777 is a negative number for the criteria needed
That is it is lower than zero, i.e. ($2.00)
777 is a TextBox and on the main form.
So, if the value of the textbox 777 is less than zero the run code


If 777 < 0 Then
CI30.Visible = True
End If

Are you saying that "777" is the *name* of a text box on the form? Then
you'd better make that clear to Access:

If Me![777] < 0 Then
CI30.Visible = True
End If

 

[Dave Elliott]

Yes 777 is the name of my textbox, however the code still does not work ?
Is it that the number in 777 is a negative amount? which is what I am
checking for?
In other words, the customer has overpaid!

777 is a negative number for the criteria needed
That is it is lower than zero, i.e. ($2.00)
777 is a TextBox and on the main form.
So, if the value of the textbox 777 is less than zero the run code


If 777 < 0 Then
CI30.Visible = True
End If

Are you saying that "777" is the *name* of a text box on the form? Then
you'd better make that clear to Access:

If Me![777] < 0 Then
CI30.Visible = True
End If

--
Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)

 

[Dirk Goldgar]

Yes 777 is the name of my textbox, however the code still does not
work ? Is it that the number in 777 is a negative amount? which is
what I am checking for?
In other words, the customer has overpaid!

777 is a negative number for the criteria needed
That is it is lower than zero, i.e. ($2.00)
777 is a TextBox and on the main form.
So, if the value of the textbox 777 is less than zero the run code


If 777 < 0 Then
CI30.Visible = True
End If

Are you saying that "777" is the *name* of a text box on the form?
Then you'd better make that clear to Access:

If Me![777] < 0 Then
CI30.Visible = True
End If

In what way does the code "not work"? Do you get an error message, or
does nothing happen, or what?

You mentioned that the text box [777] is on the "main form". Is this
code running on a subform of that main form If so, you need to tell
Access that [777] is not on this form, but on its parent form:

If Me.Parent![777] < 0 Then
CI30.Visible = True
End If

 

[John Vinson]

Yes 777 is the name of my textbox, however the code still does not work ?
Is it that the number in 777 is a negative amount? which is what I am
checking for?

Change the name of the textbox.

777 *IS A NUMBER*.

Access is comparing the value in the table with the numeric value 777
(which is not a negative number). You *might* be able to get around
this by enclosing the control name in brackets, but it's simply bad
design.

If you want to *see* 777 on the form use a Label or set the Caption
property of the control - but don't use 777 as the Name of the
control, use A777 or some other alphanumeric or alphabetic name
instead.

John W. Vinson[MVP]

 

[Dave Elliott]

The TextBox does not show up, and yes krap is the name of a textbox on the
main form.

If Me.krap < 0 Then
Me.CI30.Visible = True
End If

Yes 777 is the name of my textbox, however the code still does not
work ? Is it that the number in 777 is a negative amount? which is
what I am checking for?
In other words, the customer has overpaid!

777 is a negative number for the criteria needed
That is it is lower than zero, i.e. ($2.00)
777 is a TextBox and on the main form.
So, if the value of the textbox 777 is less than zero the run code


If 777 < 0 Then
CI30.Visible = True
End If

Are you saying that "777" is the *name* of a text box on the form?
Then you'd better make that clear to Access:

If Me![777] < 0 Then
CI30.Visible = True
End If

In what way does the code "not work"? Do you get an error message, or
does nothing happen, or what?

You mentioned that the text box [777] is on the "main form". Is this
code running on a subform of that main form If so, you need to tell
Access that [777] is not on this form, but on its parent form:

If Me.Parent![777] < 0 Then
CI30.Visible = True
End If

--
Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)

 

[Dave Elliott]

Thanks for heads up on the naming convetion thing, however I still cant get
it to work,
The TextBox does not show up, and yes krap is the name of a textbox on the
main form.

If Me.krap < 0 Then
Me.CI30.Visible = True
End If

 

[Dirk Goldgar]

The TextBox does not show up, and yes krap is the name of a textbox
on the main form.

If Me.krap < 0 Then
Me.CI30.Visible = True
End If

Yes 777 is the name of my textbox, however the code still does not
work ? Is it that the number in 777 is a negative amount? which is
what I am checking for?
In other words, the customer has overpaid!

777 is a negative number for the criteria needed
That is it is lower than zero, i.e. ($2.00)
777 is a TextBox and on the main form.
So, if the value of the textbox 777 is less than zero the run code


If 777 < 0 Then
CI30.Visible = True
End If

Are you saying that "777" is the *name* of a text box on the form?
Then you'd better make that clear to Access:

If Me![777] < 0 Then
CI30.Visible = True
End If

In what way does the code "not work"? Do you get an error message,
or does nothing happen, or what?

You mentioned that the text box [777] is on the "main form". Is this
code running on a subform of that main form If so, you need to tell
Access that [777] is not on this form, but on its parent form:

If Me.Parent![777] < 0 Then
CI30.Visible = True
End If

Have you changed the name of the text box, then? Did you try what I
suggested above?

You're not giving much information. Please answer every one of these
questions:

1. What are the names of both of the text boxes involved?

2. Which one is on the main form?

3. Is the other on a subform?

4. In what event is the code running?

5. On what form -- the main form or the subform -- is the code running?