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