>I needed to change a field from numeric to currency my data type of a fields in my table to then I get 4 decimals like $5.0000 type of data.
>
>I have the default set to 2 in the options and have tried the set decimals to 2 didn't work.

That is the definition of a currency field regardless of SET DECIMALS. Use the input mask property of the table to limit the decimals -- e.g., 999,999,999.99 -- assuming the table is part of a DBC.