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