Format Property in Sql statment

[Guest]

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

 

[Allen Browne]

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

 

[Guest]

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.

 

[Allen Browne]

Answered under your original post.