>
> >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
Barbara,
That will work in VFP5 (because Columns have a format property), but in
VFP3 the only way (that I know of course) is to use the dynamicBackColor
property (i.e. setting it to the ForeColor).
Regards,
Marc
If things have the tendency to go your way, do not worry. It won't last. Jules Renard.