I've created a variable (sPath) to store the location of a file in a DB using the below. The issue is it's truncating part of the path.

The path should come out as:
'C:\M5\bin\Database\Financials\ZZZ.d'

but it is coming out as:
'C:\M5\bin\Database\Financials'

I have put a break point in and 'Symbol' and 'g_sDataMode' do have values.

Anyone know why the variable is not saving the full path?

Code:
Dim sPath As String

        sPath = Application.StartupPath & "\Database\" & Sector & "\" & Symbol & "." & g_sDataMode