Failure to handle no value from Access Table

Hello chaps, I am writing a VB.Net program to retreive the database field values from a table in which several columns may contain "no values" in some rows. Database format: "Access" Error message: A first chance exception of type 'System.InvalidCastException' occurred in Microsoft.VisualBasic.dll my progam failed while running these few lines. ---------Code------- Dim s_BurialAft As String Dim s_BurialType As String Dim s_Depth As String ..... Do While Not pTableRow is nothing ..... 'error occurs when it runs to the below line s_BurialAft = pTableRow.Value(i_xBurialAft) 'i_x_BurialAft is the column index no s_BurialType = pTableRow.Value(i_xBurialType) '_xBurialType is the column index no s_Depth = pTableRow.Value(i_xDepth) 'i_xDepth is the column index no ..... pTableRow = pTableRow.NextRow Loop --- end of code --- But when i converted the few lines of codes: s_BurialAft = CType(pTableRow.Value(i_xBurialAft), String) s_BurialType = CType(pTableRow.Value(i_xBurialType), String) s_Depth = CType(pTableRow.Value(i_xDepth), String) Error message: (Same message) A first chance exception of type 'System.InvalidCastException' occurred in Microsoft.VisualBasic.dll Can anybody find out what problem here. Or how to test null / no values out before assigning to the string variables. Thanks a lot! E Lau

• › How to read line value from txt
• › How to get line value from txt file in cmd
• › taking a value from a text file
• › [Solved] excel VBA finds value from table in powerpoint
• › Use MS-DOS For Loop to retrieve values from Excel fields
• › [Solved] How to get each line value from txt file in cmd
• › [Solved] How to strip invalid characters from SET /P user input