access / asp net format help needed!!!

[tinomesa]

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

:confused: