Fixed formatting plz Help!!

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

The following code will not work as scripted below but should bring you on the right track



dim db as object

dim qd as object

dim qf as object



set db=currentdb

set qd = db.allqueries("MyQueryName")

qd.Fields("MyFieldName").Format = "Fixed"

qd.close

db.close

set nothing blabla