This problem should be removed because:
Problem with Microsoft Office Access 2003 (077-02871) for PC
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?
Solutions (1)
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.
-
MS Access
I am able to export data from a MS Access Table to a text file in C Dirve. Howwver, before some columns I must append three zeros. For...
-
FORMULA PROBLEM IN MS EXCEL
WHEN I SUM THE CELLS VELUE THEN IT SHOW ME 0(zero) BUT IT'S TOTAL IS NOT 0(zero)
-
Sometimes when I use a formula in Excel 2003 it
Sometimes when I use a formula in Excel 2003 it will not calculate - it is as if the formula does not exist. an additional problem is that...
-
in my Ms excel 2007
in my Ms excel 2007 can't save.how can i fix it
Add Your Solution
-
Microsoft Access Report Creation
Creating a report in columnar form (details / titles down the left hand side). I want multiple columns to appear on the...
-
how to use validation rule
how to use validation rule in microsoft access?
-
what is the maximum number
what is the maximum number of records that Access 2003 can process in a query? I am finding that when I bring a large...
-
i wants download ms access
i wants download ms access 2003
See all Microsoft Office Access 2003 (077-02871) for PC Problems
Fix-O-Meter
85
85 people viewed this problem
- 0 people are following this problem. Be the first!
Top Microsoft Business and Productivity Software Experts
Verification:
Please enter the characters below to complete your post
Can't read it? Try a different one

this code should be added to the "afterupdate" event of the field.
here "ok" is the name of a sample field.