Microsoft Office Access 2003 (077-02871) for PC Logo

Related Tags:

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?

Posted by avatar on Jul 13, 2009

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.

    • By avatarkagitapus Aug 12, 2009

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

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

Add Your Solution

Microsoft Office Access 2003 (077-02871) for PC Unsolved Problems

See all Microsoft Office Access 2003 (077-02871) for PC Problems

Related Topics