(513) 874-3306
We fix and repair laptop motherboard no video, no...
Answer
can we enter data in table through query calculation
Problem for Microsoft Office Access 2003 (077-02871) for PC
MS Access: Zero value to display as "New"
Solution #1
posted on Aug 10, 2009
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.
here "ok" is the name of a sample field.
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.
Comments:
Aug 12, 2009
- this code should be added to the "afterupdate" event of the field.here "ok" is the name of a sample field.
Yes
No
Popular Solutions for Microsoft Office Access 2003
Questions and Unsolved Problems for Microsoft Office Access 2003
Do you recommend Microsoft Office Access 2003 (077-02871) for PC?
Answer
Answer
export report from acces 2007 to excel
Answer
different files. How do I do that
Answer
Hey everyone. Can anyone help me come up with a script that will allow me to import a text file...
(More)
Answer
I am getting the message "Module not found" after deleting a form that I no longer use...
(More)
Ask our Experts
Browse popular Problems
More Common Problems
Most Common Problems for:
For Microsoft Office Access 2003 ...:
Top Business and Pro... Experts
Experience:
Experienced a lot in computer troubleshooting.
Knowledgeable about cellular phones.
Ask Me
Top Computer & Laptop Repair
Best Business and Productivity
Recommended by Owners
Recommended by Owners
