My VB Form is broken on the database load/fill portion of the load form. It is supposed to open a form, & load data from the last record in the DB. It never gets to the loading of the form.

I must have changed a datatype in the database & I cannot recall it's original datatype or I am formatting form data incorrectly. Using a working in-service version of the program now also bombs.

Due to lengthy code, please advise what might be required to help diagnose my issue. Below is the LOAD FORM piece with the line it is dying at highlighted in bold blue. Using breakpoints + step through, nothing is noted as to the problem.

In my database, can one advise the proper datatype settings as noted in my default settings area. Please help so I can catch up on my ever growing back log. I do not know how to step through the DB access at formload to see which datatype is reportedly set incorrectly.

Code:
Public Class LoadData
    Private DV As DataView
    Private LoadForm As Boolean
    Private dtFuel As New Fuel.Fuel_TableDataTable

    Private Sub LoadData_FormClosing(sender As Object, e As FormClosingEventArgs) Handles Me.FormClosing
        Dirty()
    End Sub

    Private Sub Load_Info_Form(sender As Object, e As EventArgs) Handles MyBase.Load
        LoadForm = True
        Load_Info_TableTableAdapter.Fill(LoadInfoDataSet.Load_Info_Table)

        LoadInfoDataSetBindingSource.Position = LoadInfoDataSet.Load_Info_Table.Rows.Count - 1

        'Setting Default Values
        LoadInfoDataSet.Load_Info_Table.Columns("ACT_MILES_DIFF_CALC").DefaultValue = 0
        LoadInfoDataSet.Load_Info_Table.Columns("ACTUAL_DH_MILES").DefaultValue = 0
        LoadInfoDataSet.Load_Info_Table.Columns("ACTUAL_LOADED_MILES").DefaultValue = 0
        LoadInfoDataSet.Load_Info_Table.Columns("ADJUSTED_MILEAGE").DefaultValue = 0
        LoadInfoDataSet.Load_Info_Table.Columns("AGENT_FEE").DefaultValue = 0D
        LoadInfoDataSet.Load_Info_Table.Columns("ACT_MILES_DIFF_CALC").DefaultValue = 0D
        LoadInfoDataSet.Load_Info_Table.Columns("ARRIVE_DATE_01").DefaultValue = Date.Today
        LoadInfoDataSet.Load_Info_Table.Columns("ARRIVE_DATE_90").DefaultValue = Date.Today
        LoadInfoDataSet.Load_Info_Table.Columns("ARRIVE_TIME_01").DefaultValue = "00:00"
        LoadInfoDataSet.Load_Info_Table.Columns("ARRIVE_TIME_90").DefaultValue = "00:00"
        LoadInfoDataSet.Load_Info_Table.Columns("ARRIVE_EARLY").DefaultValue = "NO"
        LoadInfoDataSet.Load_Info_Table.Columns("BOL").DefaultValue = "N / A"
        LoadInfoDataSet.Load_Info_Table.Columns("BOL_WEIGHT").DefaultValue = 0
        LoadInfoDataSet.Load_Info_Table.Columns("CLAIM").DefaultValue = "NO"
        LoadInfoDataSet.Load_Info_Table.Columns("CLAIM_AMOUNT").DefaultValue = 0D
        LoadInfoDataSet.Load_Info_Table.Columns("DATE_PAID").DefaultValue = Date.Today
        LoadInfoDataSet.Load_Info_Table.Columns("DEF_GALS_TOT").DefaultValue = 0D
        LoadInfoDataSet.Load_Info_Table.Columns("DEF_PURCHASED").DefaultValue = 0D
        LoadInfoDataSet.Load_Info_Table.Columns("DEPART_DATE_01").DefaultValue = Date.Today
        LoadInfoDataSet.Load_Info_Table.Columns("DEPART_DATE_90").DefaultValue = Date.Today
        LoadInfoDataSet.Load_Info_Table.Columns("DEPART_TIME_01").DefaultValue = "00:00"
        LoadInfoDataSet.Load_Info_Table.Columns("DEPART_TIME_90").DefaultValue = "00:00"
        LoadInfoDataSet.Load_Info_Table.Columns("DETENTION_PAID").DefaultValue = 0D
        LoadInfoDataSet.Load_Info_Table.Columns("DH_MILES_DIFF_CALC").DefaultValue = 0
        LoadInfoDataSet.Load_Info_Table.Columns("DISPATCH_DATE").DefaultValue = Date.Today
        LoadInfoDataSet.Load_Info_Table.Columns("DROP_CONFIRM").DefaultValue = "N / A"
        LoadInfoDataSet.Load_Info_Table.Columns("DROPPED_EARLY").DefaultValue = "NO"
        LoadInfoDataSet.Load_Info_Table.Columns("DROP_LOCATION").DefaultValue = "N / A"
        LoadInfoDataSet.Load_Info_Table.Columns("EQUIP_WASHING_COST").DefaultValue = 0D
        LoadInfoDataSet.Load_Info_Table.Columns("EQUIP_WASH_REIMBURSE").DefaultValue = 0D
        LoadInfoDataSet.Load_Info_Table.Columns("EXTRA_PAY_RECEIVED").DefaultValue = 0D
        LoadInfoDataSet.Load_Info_Table.Columns("EXTRA_STOP_PICKUP_PAY").DefaultValue = 0D
        LoadInfoDataSet.Load_Info_Table.Columns("FAX_COST").DefaultValue = 0D
        LoadInfoDataSet.Load_Info_Table.Columns("FS_DIFF1_CALC").DefaultValue = 0D
        LoadInfoDataSet.Load_Info_Table.Columns("FS_DIFF2_CALC").DefaultValue = 0D
        LoadInfoDataSet.Load_Info_Table.Columns("FSA_DIFF1_CALC").DefaultValue = 0D
        LoadInfoDataSet.Load_Info_Table.Columns("FSA_DIFF2_CALC").DefaultValue = 0D
        LoadInfoDataSet.Load_Info_Table.Columns("FUEL_COST_AVG").DefaultValue = 0D
        LoadInfoDataSet.Load_Info_Table.Columns("FUEL_PROFIT_LOSS").DefaultValue = 0D
        LoadInfoDataSet.Load_Info_Table.Columns("FUEL_PURCHASED").DefaultValue = 0D
        LoadInfoDataSet.Load_Info_Table.Columns("FUEL_PURCHASED").DefaultValue = 0D
        LoadInfoDataSet.Load_Info_Table.Columns("FUEL_REIMBURSE_TOTAL").DefaultValue = 0D
        LoadInfoDataSet.Load_Info_Table.Columns("FUEL_SUR_PAID").DefaultValue = 0D
        LoadInfoDataSet.Load_Info_Table.Columns("FUEL_SUR_TRUCK").DefaultValue = 0D
        LoadInfoDataSet.Load_Info_Table.Columns("FUEL_SUR_ADJ_FAX").DefaultValue = 0D
        LoadInfoDataSet.Load_Info_Table.Columns("FUEL_SUR_ADJ_PAID").DefaultValue = 0D
        LoadInfoDataSet.Load_Info_Table.Columns("FUEL_SUR_ADJ_TRUCK").DefaultValue = 0D
        LoadInfoDataSet.Load_Info_Table.Columns("GALS_PURCHASED").DefaultValue = 0D
        LoadInfoDataSet.Load_Info_Table.Columns("LH_DIFF1_CALC").DefaultValue = 0D
        LoadInfoDataSet.Load_Info_Table.Columns("LH_DIFF2_CALC").DefaultValue = 0D
        LoadInfoDataSet.Load_Info_Table.Columns("LINEHAUL_FAX").DefaultValue = 0D
        LoadInfoDataSet.Load_Info_Table.Columns("LINEHAUL_PAID").DefaultValue = 0D
        LoadInfoDataSet.Load_Info_Table.Columns("LINEHAUL_TRUCK").DefaultValue = 0D
        LoadInfoDataSet.Load_Info_Table.Columns("LUMPER_FEES").DefaultValue = 0D
        LoadInfoDataSet.Load_Info_Table.Columns("LUMPER_REIMBURSEMENT").DefaultValue = 0D
        LoadInfoDataSet.Load_Info_Table.Columns("MULTI_STOP").DefaultValue = "NO"
        LoadInfoDataSet.Load_Info_Table.Columns("OUT_OF_POCKET_FUEL").DefaultValue = 0D
        LoadInfoDataSet.Load_Info_Table.Columns("OUT_OF_ROUTE_MILES").DefaultValue = 0
        LoadInfoDataSet.Load_Info_Table.Columns("PALLET_COUNT").DefaultValue = 0
        LoadInfoDataSet.Load_Info_Table.Columns("PER_MILE_RATE_FAX").DefaultValue = 0D
        LoadInfoDataSet.Load_Info_Table.Columns("PER_MILE_RATE_PAID").DefaultValue = 0D
        LoadInfoDataSet.Load_Info_Table.Columns("PER_MILE_RATE_TRUCK").DefaultValue = 0D
        LoadInfoDataSet.Load_Info_Table.Columns("PIECE_COUNT").DefaultValue = 0
        LoadInfoDataSet.Load_Info_Table.Columns("PM_DIFF1_CALC").DefaultValue = 0D
        LoadInfoDataSet.Load_Info_Table.Columns("PM_DIFF2_CALC").DefaultValue = 0D
        LoadInfoDataSet.Load_Info_Table.Columns("PRIME_LOADED_MILES").DefaultValue = 0
        LoadInfoDataSet.Load_Info_Table.Columns("PRIME_DH_MILES").DefaultValue = 0
        LoadInfoDataSet.Load_Info_Table.Columns("PU_CONFIRM").DefaultValue = "N / A"
        LoadInfoDataSet.Load_Info_Table.Columns("PU_DRP_TRLR_FEE").DefaultValue = 0D
        LoadInfoDataSet.Load_Info_Table.Columns("PU_NUMBER").DefaultValue = "N / A"
        LoadInfoDataSet.Load_Info_Table.Columns("REEFER_PURCHASED").DefaultValue = 0D
        LoadInfoDataSet.Load_Info_Table.Columns("REEFER_REIMBURSEMENT").DefaultValue = 0D
        LoadInfoDataSet.Load_Info_Table.Columns("REEFER_FUEL_LVL").DefaultValue = "FULL"
        LoadInfoDataSet.Load_Info_Table.Columns("REEFER_FUEL_PROFIT_LOSS").DefaultValue = 0D
        LoadInfoDataSet.Load_Info_Table.Columns("REV_TOTAL_FAX").DefaultValue = 0D
        LoadInfoDataSet.Load_Info_Table.Columns("REV_TOTAL_PAID").DefaultValue = 0D
        LoadInfoDataSet.Load_Info_Table.Columns("REV_TOTAL_TRUCK").DefaultValue = 0D
        LoadInfoDataSet.Load_Info_Table.Columns("RFR_FUEL_SUR_FAX").DefaultValue = 0D
        LoadInfoDataSet.Load_Info_Table.Columns("RFR_FUEL_SUR_PAID").DefaultValue = 0D
        LoadInfoDataSet.Load_Info_Table.Columns("RFR_FUEL_SUR_TRUCK").DefaultValue = 0D
        LoadInfoDataSet.Load_Info_Table.Columns("RFR_GALS_TOT").DefaultValue = 0D
        LoadInfoDataSet.Load_Info_Table.Columns("RFER_FUEL_TAX_REFUND").DefaultValue = 0D
        LoadInfoDataSet.Load_Info_Table.Columns("SCALE_WEIGHT").DefaultValue = 0
        LoadInfoDataSet.Load_Info_Table.Columns("SCALES_COST").DefaultValue = 0D
        LoadInfoDataSet.Load_Info_Table.Columns("SCALES_REIMBURMENT").DefaultValue = 0D
        LoadInfoDataSet.Load_Info_Table.Columns("SEAL").DefaultValue = "N / A"
        LoadInfoDataSet.Load_Info_Table.Columns("TOLL_COST").DefaultValue = 0D
        LoadInfoDataSet.Load_Info_Table.Columns("TOLL_REIMBURMENT").DefaultValue = 0D
        LoadInfoDataSet.Load_Info_Table.Columns("TOTAL_DRIVEN_MILES").DefaultValue = 0
        LoadInfoDataSet.Load_Info_Table.Columns("TOTAL_MILES_DIFF_CALC").DefaultValue = 0
        LoadInfoDataSet.Load_Info_Table.Columns("TRACTOR_FUEL_TAX_REFUND").DefaultValue = 0D
        LoadInfoDataSet.Load_Info_Table.Columns("TRIP_MPG").DefaultValue = 0D
        LoadInfoDataSet.Load_Info_Table.Columns("TRIP_END_MILES").DefaultValue = 0
        LoadInfoDataSet.Load_Info_Table.Columns("TRIP_START_MILES").DefaultValue = 0
        LoadInfoDataSet.Load_Info_Table.Columns("TRLR_SHUTTLE_PAY").DefaultValue = 0
        LoadInfoDataSet.Load_Info_Table.Columns("TRUCK_FUEL_PROFIT_LOSS").DefaultValue = 0D

        calc()
        DV = New DataView(LoadInfoDataSet.Load_Info_Table)
        LoadForm = False
    End Sub