thanks Pat for the reply and I did try and use your suggestion of Space(2) & Field_Name but it doesn't work inside a VBA module that has a SQL statement.
I ended up using MajP's suggestion above of using labels and turning off column headers. Labels allows for more formatting flexibility.
Help please!
I have a list box that is populated by a SQL query in VBA. I want to pad the column/field name with 2 leading spaces.
Right now I am using this in my SQL statement:
T_Invoice.Ship_Date AS [SHIP DATE]
to display SHIP DATE as the column heading in the list box which works fine...