>This is one of the biggest hurdles in converting our FPD2.6 app to VFP... The programmer used a 16 digit numeric field for the account number and when I open the accounts table in VFP, every account ending with 9 is rounded up !!!

Larry,

I don't know if this will help or not, but maybe it's just the display that's rounding up? With 16 digit numeric account numbers you should still be OK... a spot check with a test program seems to indicate that i = val(str(i, 16, 0)) for 16-digit integers including those that end in 9. (I tested it for i = 1234567891000009 to 1234567899999999 step 10). Therefore, you could consider adding a character account number field to the table, say cAccountNumber C(16), and populating it with str(nAccountNumber, 16, 0). You could run a quick check to verify that val(cAccountNumber) = nAccountNumber for every record in the table, then delete the nAccountNumber column from the table to avoid any further problems.