>
> >>
> >> >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
>
> Marc, You're quite right about the grid columns not having format
> properties in VFP3, but the original question was for "textboxes on a form
> for numeric fields", where the Z format works in both VFP3 and VFP5.
>
> Barbara
Barbara,
Hm. You are right again ...
Marc
If things have the tendency to go your way, do not worry. It won't last. Jules Renard.