🚀 go-pugleaf

Hello,

Programmer Dude <Chris@Sonnack.com> ����� �
���������:3F6775C4.B68635B6@Sonnack.com...
> Vladimir wrote:
>
> > But why can't I get access to Properties collection of Field object?
>
> You can.  Row Source is *NOT* a property of a Field.  It's a property
> of the ComboBox on the Form in Access.
>

Then how can I get those sort of properties?

> > Also when I execute query SELECT <field> FROM <table> in Access
> > Query Designer I get string. When I execute through ADO I get
> > number.
>
> Are you saying you get "Above" in that case and "1" if you issue
> an SQL statement through VC++?  That's.... impossible.  Something
> else is going on.  Are you sure the Query Designer isn't linking
> in a table or doing some sort of lookup?
>

It is possible. You can create your own table in Access with one field
having lookup with following properties:

Display control = Combo Box
Row ource type = Value list
Row source = 1;"qwe";2;"asd";3;"zxc"
Bound column = 1
Column count = 2
Column heads = No
Column widths = 0cm;4cm
List rows = 8
List width = 4cm
Limit to list = Yes

Then fill table with data and enter MANUALLY in Query Designer (View / SQL
mode) this text: SELECT <field> FROM <table> - and you will get strings.

> Take a look under the hood of that query and maybe look at the
> definition of the table in question.  Access can link to lookup
> tables--did you design the database or did someone else?
>

I'm not but I've tried to design table as described above.

Regards,
Vladimir.