error ????????

  • Thread starter Thread starter Alexander
  • Start date Start date
A

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
 
Alexander said:
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
Click to expand...

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.
 
Back
Top