Q:

Microsoft Access hide 0 from field

In Access reports, I am able to hide the fields with 0 with the Textbox Format in the Property Sheet with this: 
0;;"";
The code above will hide all the zeroes from all the fields in that column. However, without using the semi-colons, (actually only using a single character), is it possible to do the same as the code above?

A:

The character you are looking for is hash: #
Read Format Property - Number and Currency Data Types for more information. For the most part, check MSDN. The Office articles seem to have got worse and worse.

