Replace a number with text string in report

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How do I replace a number value with a text string in a report? The cell
format is set to numbers so that it sorts properly, but instead of printing
"0" in my report I want it to display "NB". Any ideas?
 
Set the Format property to something like:
#,##0.00;(#,##0.00);"NB";"Null"
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Filtering subreports on main report 0
MS word Find and Replace using Regex - Help required 0
Access 2007,reports,VBA 2
A03 - count in report footer gives me #Error? 0
Need to format a number in a report, but no number options come up 2
same report displays in 2003 but not in 2007 2
Sorting on the value of a text box in each record? 2
Report display/printout shrunk 1

Back
Top