[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now


Plus or Minus numbers

Posted on 2007-07-26
Medium Priority
Last Modified: 2010-04-23
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.
Question by:robultra17
  • 3
LVL 61

Expert Comment

ID: 19573376
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

LVL 61

Accepted Solution

mbizup earned 2000 total points
ID: 19573380
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

Author Comment

ID: 19574061
You are a bloody star.

Thank you very much.
LVL 61

Expert Comment

ID: 19574064
Glad to help :-)

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Instead of error trapping or hard-coding for non-updateable fields when using QODBC, let VBA automatically disable them when forms open. This way, users can view but not change the data. Part 1 explained how to use schema tables to do this. Part 2 h…
Sometimes MS breaks things just for fun... In Access 2003, only the maximum allowable SQL string length could cause problems as you built a recordset. Now, when using string data in a WHERE clause, the 'identifier' maximum is 128 characters. So, …
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …
Suggested Courses

834 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question