Plus or Minus numbers

Hi and thanks in advance for any help

I have a report a 2 text boxes called

Traverse reading 1
Traverse error reading 1 (T)

Traverse reading 1 is entered by the user on a form and  Traverse error reading 1 (T) is the limit for traverse reading 1.

I use the following code on the report which shows a label to tell the user if the reading is out side the limits.

If Me.Traverse_reading_1 > Me.Traverse_error_reading_1__T_ Then
denotesreading1.Visible = True
Denotes.Visible = True
End If


The problem im having is if the reading is entered a minus number then the denotes labels dont show.

The Traverse error reading 1 (T) entered as a plus figure e.g 0.003

I have no idea how to solve this.

Im running Microsoft Access 2003.
robultra17Asked:
Who is Participating?
 
mbizupConnect With a Mentor Commented:
Correction... I omitted a space:

If abs(Me.Traverse_reading_1) > abs(Me.Traverse_error_reading_1__T_ ) Then
denotesreading1.Visible = True
Denotes.Visible = True
End If
0
 
mbizupCommented:
Do you want to compare absolute values (without signs)?

If abs(Me.Traverse_reading_1) > abs(Me.Traverse_error_reading_1__T_ )Then
denotesreading1.Visible = True
Denotes.Visible = True
End If

0
 
robultra17Author Commented:
You are a bloody star.

Thank you very much.
0
 
mbizupCommented:
Glad to help :-)
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.