extract part of a field

[maceslin]

I amtrying to extract the first letter and only the first lette from
cboClassification to use in an text box.

The properties of cboClassification are
RowSource: SELECT tblClass.ClassIDPK, tblClass.classification FROM
tblClass ORDER BY [classification];

Bound Column 1
ColumnCount 2

The control source for my text box is:
=left$([cboClassification],1)

this returns the ClassIDPK from the bound colum of cboClassification
while I desire the classification text associated with the number.

Have tried numeous combinations to make it work with no luck.

Ay help out there

Thanks
Dave

 

[George Nicholson]

=left([cboClassification].Column(1),1)

Column is zero-based so Column(1) refers to the 2nd column.

 

[maceslin]

=left([cboClassification].Column(1),1)

Column is zero-based so Column(1) refers to the 2nd column.

--
HTH,
George

I amtrying to extract the first letter and only the first lette from
cboClassification to use in an text box.

The properties of cboClassification are
RowSource: SELECT tblClass.ClassIDPK, tblClass.classification FROM
tblClass ORDER BY [classification];

Bound Column 1
ColumnCount 2

The control source for my text box is:
=left$([cboClassification],1)

this returns the ClassIDPK from the bound colum of cboClassification
while I desire the classification text associated with the number.

Have tried numeous combinations to make it work with no luck.

Ay help out there

Thanks
Dave- Hide quoted text -

- Show quoted text -

That answered the mail-- Thanks