> > >> > >> >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