Question about Microsoft Office Access 2003 (077-02871) for PC

1 Answer

MS Access: Zero value to display as "New"

MS Access: How do I get any expression that is equals to zero to display as "New" instead of 0?

Posted by on


1 Answer

  • Level 1:

    An expert who has achieved level 1.


    An expert who has answered 20 questions.


    An expert that hasĀ over 10 points.


    An expert whose answer gotĀ voted for 2 times.

  • Contributor
  • 21 Answers

Is that field a resultant of an expression or it will be filled manually? If it is a manually updated field then use the following expression in the code builder.

If ok.Value = "0" Then
ok.Value = "New"
End If
If the field is a resultant of an expression then add some more lines similar to above to get required results.

Posted on Aug 10, 2009

  • kagitapus Aug 12, 2009

    this code should be added to the "afterupdate" event of the field.

    here "ok" is the name of a sample field.



1 Suggested Answer

  • 2 Answers

SOURCE: I have freestanding Series 8 dishwasher. Lately during the filling cycle water hammer is occurring. How can this be resolved

a 6ya expert can help you resolve that issue over the phone in a minute or two.
best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.
the service is completely free and covers almost anything you can think of (from cars to computers, handyman, and even drones).
click here to download the app (for users in the US for now) and get all the help you need.

Posted on Jan 02, 2017


Add Your Answer

Uploading: 0%


Complete. Click "Add" to insert your video. Add



Related Questions:

1 Answer

Is x=4 a solution for 2x+4=0

Easy to verify. Put 4 instead of x in the equation. You get 2*4+4?=0. Obviously 2*4+4=3*4=12, and 12 is not equal to zero. The value x=4 is not a solution of the equation.
2x+4=0, gives 2x=-4 and x=-4/2=-2

Feb 08, 2012 | Office Equipment & Supplies

1 Answer

My baking is set on celcius instead of farenheit.

sorry i dont know how to switch it for you but i do know how to convert c to f
Degrees c times 1.8 plus 32 equals f temp
Example 100c is boiling point so 100 times 1.8 equals 180 add 32 to that equals 212

zero degrees c is freezing point
zero times 1.8 is 0 plus 32 is 32
200 times 1.8 is 360 plus 32 is 392 ect ect ect

Jul 22, 2011 | Whirlpool Kitchen Ranges

1 Answer

6x squared - 10x =0

Factor out 3X
The expression is equal to zero if one of the factors on the left side equals zero.
1st solution: 3X=0, thus X=0
2nd solution 2X-5 = 0 if X=5/2

Sep 10, 2010 | Office Equipment & Supplies

1 Answer

Explain 1 divided by 0

In mathematics, a division is called a division by zero if the divisor is zero. Such a division can be formally expressed as a / 0 where a is the dividend. Whether this expression can be assigned a well-defined value depends upon the mathematical setting. In ordinary (real number) arithmetic, the expression has no meaning, as there is no number which, multiplied by 0, gives a (a?0).
In computer programming, an attempt to divide by zero may, depending on the programming language, generate an error message or may result in a special not-a-number value (see below).
Historically, one of the earliest recorded references to the mathematical impossibility of assigning a value to a / 0 is contained in George Berkeley's criticism of infinitesimal calculus in The Analyst; see Ghosts of departed quantities.

Sep 03, 2010 | Computers & Internet

1 Answer

What causes some parabolas to have no x-intercepts?

If the parabola has its concavity turned downward and it maximum value is lower than 0 then the value of the functions are always negative (never reach 0).
Similarly, if the parabola has it concavity turned upward, and its minimum value is positive, then all the values of the functions are positive (never reach zero). Thus if y is never equal to zero the function has no x intercepts.
The concavity is called by some people the mouth.

Aug 20, 2010 | SoftMath Algebrator - Algebra Homework...

1 Answer

Casio fx-7400G PLUS cubic solver?

First let us repair the terminology.

  1. You can evaluate any expression (find the value of any expression for a particular value of its variable).Store a value in the variable, say X. Key in the expression and press [EXE].
  2. You can consider your expression(should not contain a relational operator such as =, greater than, less than, greater than or equal to, less than or equal to) to be a function Y1(x) = expression and graph it, or generate a table for it. You will have several values of the function calculated at various points.
  3. You can set your expression equal to 0 and find the particular value(s) of the variable (the unknown) that make the equality TRUE. That is called solving an equation.
I am not sure that it has a solver (solving an equation or an inequation) but you can always draw your expression as a function and explore the graph (SKTCH) to locate the roots (or zeros) of the functions (the values of the variable where the function equals zero.) That is called solving graphically.

Hope it helps.
Thank you for using FixYa and for rating this solution.

Nov 05, 2009 | Casio FX-7400G Plus Calculator

1 Answer

Hi.I've a canon mp110. on display there's written ''bottom ink absorber is almost full''. I cleaned and changed colours but there's no solution. please help me, thanks

  1. You will include printer.
  2. press button MENU, then SCAN, COPY and again SCAN - they entered into the service mode.
  3. select NVRAM ACCESS and further BY OK.
  4. select SET Abs- m level and advance value equal to zero.
  5. select SET Abs- r level (if there is) and also you will establish into zero.
  6. you will turn off printer by button POWER.

Oct 27, 2009 | Canon Office Equipment & Supplies

4 Answers

MP130 Ink waste tank is full how do I empty it

To reset the Waste Ink Counter:---------------------
  • Press Menu----------- Scan -------------- Copy----------- Scan, to enter Service menu.
  • Scroll to option " Service Menu Counter Access ".
  • Press OK.
  • After entering Scroll to " ABS-M DOT COUNT ".
  • Use arrows to reset the value to ZERO.
  • Press Stop or Reset.
Thats the Solution.
To Clean Waste Ink Pads:-----------------------------
  • Open the cover ( the cover you open to replace the catridges ).
  • Locate the Waste Ink Pads which are situated in the or under the Catridge Slider.
  • Dry up Waste Ink Pads ( You should wear Gloves when holding them).
  • Rinse the pads with Alcohol and make them dry.
  • Replace Pads .Then Set them. Make sure they are sitted properly.
Thank you Sir, I hope I helped you. Have a nice day.

Sep 21, 2009 | Canon PIXMA MP130 All-In-One InkJet...

1 Answer

Pc draft fractions

if you are using MS Excel, you can type fractions by typing 0 1/2 instead of typing 1/2 only. All fractions must be preceded by 0 (zero).


Jul 04, 2009 | Computers & Internet

2 Answers


The cells you are trying to sum are probably text and not numeric values. Format them as number or convert them to numbers.

Apr 18, 2009 | Microsoft Office Excel 2003 for PC

Not finding what you are looking for?
Microsoft Office Access 2003 (077-02871) for PC Logo

Related Topics:

312 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Computers & Internet Experts

micky dee

Level 3 Expert

2775 Answers

Piyal Perera
Piyal Perera

Level 3 Expert

528 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18394 Answers

Are you a Microsoft Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides