MSAccess Column Format property
-
Hi, I 'm Using ADOX from VC(I suppose ADO VB is same that ADO VC) to create tables in Access 2000 and Access 97, containing several columns/fields with the (Yes/No) or(datatime) data type. The format property of these fields is blank and needs to be set to (yes/no) or (format date). I need to make this change by using code and not manually, unfortunatly I can't see any way of accessing the Format property of the field. Is there somebody who know how can I chande Format Property From ADO? Or is there some SQL Statement that can do it? I.e. Something like that: "ALTER TABLE MyTable ALTER COLUMN DataTimeField DataTime (here my format string)" --> ("Medium Date") or ("Long Data") or "ALTER TABLE MyTable ALTER COLUMN YesOrNo YESNO(here my format string)" --> ("Yes/No") or ("True/False") Regards: KalliMan.