error ????????

[Alexander]

Column(1), which is 2d in a table, is text(50).

Somehow if it's only a number (45 or 145) it's Ok. But, If
it's a combination of a number with letter (45B) it
generates a mistake #0.

Dim strString As String

strString = CCur(Me.cboComboBox.Column(1))

Any advice would be appreciated.

Thanks

 

[Dirk Goldgar]

Column(1), which is 2d in a table, is text(50).

Somehow if it's only a number (45 or 145) it's Ok. But, If
it's a combination of a number with letter (45B) it
generates a mistake #0.

Dim strString As String

strString = CCur(Me.cboComboBox.Column(1))

Any advice would be appreciated.

Thanks

I don't understand. If you use the CCur function (Convert to Currency)
on a string that can't be interpreted as currency, of course you'll get
an error -- though it should be error 13, Type Mismatch.