>I would like to be able to suppress zeroes from showing up in text boxes on a form for numeric fields. If my table has numeric fields, the default is to display zeroes in the text boxes. The only way around it so far I have found is to use charater fields in my database, but then the data is automatically left justified, and I have to do VAL() on them every time I want to do math.
>
>Any suggestions? Thanks in advance.
Karl, put a Z in the format property. This tells the textbox to show a blank instead of a 0
Barbara