>In VFP browses a numeric field that has never had a value entered appears as blank. If a value, say zero, is entered, the value appears and if it is deleted, it will still display zero.
>
>How does one determine whether a field has ever had a value entered?
>
>Thanks
To add to what the others have said, you can use the ISBLANK() function to determine if the field is blank. But you'll have to programmatically control access to the field(s) and determine on the fly if a value has (not) been entered. Depending on your requirements, ss Ed suggested, probably using NULLs is the better way to go.
Bill
William A. Caton III
Software Engineer
MAXIMUS
Atlanta, Ga.