I am writing a .net application with an access 2000 data store.
My code creates a table on the fly, I have a field that needs to be 11 characters long and right justified, if I manually enter Fixed in the fields format property box it works great, but I need to be able to do it programatically.
This qery seems to run OK but it does not alter the format property???
UPDATE TinoMesa SET [PC-IN-RETAIL] = FORMAT ([PC-IN-RETAIL],Fixed);
this one does not work either (no error messages either...???)
UPDATE TinoMesa SET [PC-IN-RETAIL] = FORMAT$ ([PC-IN-RETAIL],Fixed);
please help
My code creates a table on the fly, I have a field that needs to be 11 characters long and right justified, if I manually enter Fixed in the fields format property box it works great, but I need to be able to do it programatically.
This qery seems to run OK but it does not alter the format property???
UPDATE TinoMesa SET [PC-IN-RETAIL] = FORMAT ([PC-IN-RETAIL],Fixed);
this one does not work either (no error messages either...???)
UPDATE TinoMesa SET [PC-IN-RETAIL] = FORMAT$ ([PC-IN-RETAIL],Fixed);
please help