 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / General 1 / February 2005me.cb.Type?
Hello, I'm trying to create a change log for database I get a runtime error 438 while tying to get the type of a bound combo-box (table/query) control. How am I supposed to get the type. It even works for other combobox with a value list. What don't I understand. I'm using DAO. I would like the datatype of the field and not the data entered. Thanks Tim Forgot to add that I'm using Access 2002 Tim > Forgot to add that I'm using Access 2002 > > Tim you may need to go through the columns collection, as a combobox can have any number of columns. So it's probably cboSomeCombo.Column(x).Type > How am I supposed to get the type. It even works for other combobox > with a value list. What don't I understand. I'm using DAO. I would like > the datatype of the field and not the data entered. me.cb.RowSourceType  SignatureTim http://www.ucs.mun.ca/~tmarshal/ ^o< /#) "Burp-beep, burp-beep, burp-beep?" - Quaker Jake /^^ "Whatcha doin?" - Ditto "TIM-MAY!!" - Me >> How am I supposed to get the type. It even works for other combobox >> with a value list. What don't I understand. I'm using DAO. I would like >> the datatype of the field and not the data entered. > > me.cb.RowSourceType Sorry, misread, disregard. SignatureTim http://www.ucs.mun.ca/~tmarshal/ ^o< /#) "Burp-beep, burp-beep, burp-beep?" - Quaker Jake /^^ "Whatcha doin?" - Ditto "TIM-MAY!!" - Me >I'm trying to create a change log for database >I get a runtime error 438 while tying to get the type of a bound >combo-box (table/query) control. >How am I supposed to get the type. It even works for other combobox >with a value list. What don't I understand. I'm using DAO. I would like >the datatype of the field and not the data entered. You want the datatype of the _field_, not of the control. So, you want to look at Me.Recordsource.Fields("Field name of bound control").Type Obviously, you'll need to change the field name to whatever the heck the *real* name of the control's field is... You also need to realize that what you are going to get is a number which will tell you what the type is. If you're looking for something like the word "Text", or "Long", or "Date", you'll need to do that translation yourself, or search this newsgroup at google groups for "dbtype" where you'll find several functions that will translate it for you. SignatureA Bird In The Hand Will Doo Doo On You. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.