Search results

  1. B

    Pad a column alias' with a leading space.

    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.
  2. B

    Pad a column alias' with a leading space.

    Great suggestion and thank you!
  3. B

    Pad a column alias' with a leading space.

    Formatting. Trying to center the column name in the list box.
  4. B

    Pad a column alias' with a leading space.

    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...
Back
Top Bottom