Hi, I am trying to populate a listbox based of ADO recordset from access database. That works fine. My problem is the last column in the listbox is a currency field but there is no formating in the listbox. So I added a piece of code in hopes that it will format to currency. This all seems to a work, but I get a run-time error 94 "Invalid Use of Null" Any suggestion how I can get around this error? The listbox populates and formats the currency column, but can't do anything because of the error. Thanks for your help.
It debugs on this line: .List(lngIndex, 8) = (Format(Val(.List(lngIndex, 8)), "$#,##0.00"))
When i hover the mouse over .List it shows .List(lngIndex, 8) = Null
Please Login or Register to view this content.