Format Property in Sql statment

Is there a way to set\change the Format Property of a filed in table by SQL
statement?

No. The Format property of a Field in a TableDef can only be set using DAO
code.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"yaya" wrote in message
...
Is there a way to set\change the Format Property of a filed in table by
SQL
statement?

Hi Allen,
First thank you.
I asked you befor few days about the Me.refresh and you answer me
("me.dierty" ...) and it;s solved the problem. BUT i have another quation
with this subject:
I have a form base on this big table i talked about (20k records).
from this form i call a vba function that change (by "db.execute" sql
statement) one of the fields in the current record that shown in this form.
to reflect the changes i use: forms![frm1].refresh and as i said it is very
very slow.
I can't use here ".dirty" because the changes made by the function and not
by the form.
Do you have another way to reflect the changes only to this specific record
in the form?

and again, you realy helped me so thanks.

Answered under your original post.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"yaya" wrote in message
...

I asked you befor few days ... BUT i have another quation
with this subject