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

• › [Solved] excel VBA finds value from table in powerpoint
• › [Solved] How to fix 'Run time error 424' in vb script
• › [Solved] Way to Automatically Look up Phone Numbers?
• › [Solved] How do I extract certain data from a xml file to a batch?
• › [Solved] copy images from a txt list to a folder
• › [Solved] how to increment numbers in a batch file using dos?
• › [Solved] I am getting script error unexpected at this time