How to display column header with spaces in it in a listbox?

[davidd31415]

Access 2000-

I am trying to display spaces in column headers in a list box with no success so far. I have tried the following xyntaxes in the Row Source:

SELECT myField AS 'My Field' FROM myTable;
SELECT myField AS My Field FROM myTable;
SELECT myField AS [My Field] FROM myTable;

Since I'm populating .RowSource from VBA I haven't tried quotation marks. When I use the query builder and then look at the SQL Access seems to use square brackets.

Any advice?

Thanks,

David

 

[PWise]

this does not work

SELECT myField AS [My Field] FROM myTable;

me.lstbox.rowsource =" SELECT myField AS [My Field] FROM myTable;"

 

[PHV]

The following works for me (ac2003):
SELECT myField AS [My Field] FROM myTable;

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886