I havea calculated field in an Access database. In the Report I would likethis field to return "NFS" [not for sale] if the valueis 0? "

Nancy 1 Reputation point

I have an Access database that tracks my artwork. On the Report for which I print gallery tags, if the calculated [Price] field =0, I would like to return "NFS" [not for sale]. How and where would I code this? I have to change the data type? The source for the Report is a query.

Access Development
Access Development
Access: A family of Microsoft relational database management systems designed for ease of use.Development: The process of researching, productizing, and refining new or existing technologies.
776 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Gustav 711 Reputation points

    Set the Format property of the textbox displaying the amount to:

    0 comments No comments