Share via

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
2022-03-30T01:11:14.877+00:00

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.
891 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Gustav 712 Reputation points MVP
    2022-03-30T08:51:13.283+00:00

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

    0.00,,"NFS"
    0 comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.