maxxximaniac
Registered User.
- Local time
- Today, 11:30
- Joined
- Oct 22, 2004
- Messages
- 80
Hey All,
I'm trying to have the checkbox keep its original format in a make-table query.
It switched the format over to a 0/-1 FALSE/TRUE and would like to keep the checkbox.
Any ideas on how to change the field type utilizing VBA?
A Calleuge of mine came up with this, but it's not working for me.
I'm trying to have the checkbox keep its original format in a make-table query.
It switched the format over to a 0/-1 FALSE/TRUE and would like to keep the checkbox.
Any ideas on how to change the field type utilizing VBA?
A Calleuge of mine came up with this, but it's not working for me.
Code:
DBEngine(0)(0).TableDefs("Table1").Fields("TestBoolean").Properties _
("DisplayControl").Value = acCheckBox
