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