me.cb.Type?

[Tim]

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

[Tim]

Re: me.cb.Type?

Forgot to add that I'm using Access 2002

Tim

[pietlinden@hotmail.com]

Re: me.cb.Type?


Tim wrote:[color=blue]
> Forgot to add that I'm using Access 2002
>
> Tim[/color]

you may need to go through the columns collection, as a combobox can
have any number of columns. So it's probably
cboSomeCombo.Co lumn(x).Type

[Tim Marshall]

Re: me.cb.Type?

Tim Marshall wrote:
[color=blue]
> Tim wrote:
>[color=green]
>> 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.[/color]
>
>
> me.cb.RowSource Type[/color]

Sorry, misread, disregard.
--
Tim http://www.ucs.mun.ca/~tmarshal/
^o<
/#) "Burp-beep, burp-beep, burp-beep?" - Quaker Jake
/^^ "Whatcha doin?" - Ditto "TIM-MAY!!" - Me

[Tim Marshall]

Re: me.cb.Type?

Tim wrote:
[color=blue]
> 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.[/color]

me.cb.RowSource Type

--
Tim http://www.ucs.mun.ca/~tmarshal/
^o<
/#) "Burp-beep, burp-beep, burp-beep?" - Quaker Jake
/^^ "Whatcha doin?" - Ditto "TIM-MAY!!" - Me