Create field with fixed format

[Liv Manto]

I need to show two decimal places on a form based on a recordset of a table that has a field - type = double, format = fixed, and decimal number = 2

I need to show 101.00 and 102.00 so if user insert a record, record would have a sequence id of 101.05.


How do I create that field by code? The table is part of a system loop that it changes everytime thats why I have to recreate the table again and again.

I can do the double, I cant do the fixed and decimal number.

Please please help.

Thanks.




NEVER MIND, I FIGURED IT OUT.

Instead of including it with the code, I tweaked how the form displays it.

Thanks.