Formatting listbox headings

  • Thread starter Thread starter Joe Holzhauer
  • Start date Start date
J

Joe Holzhauer

Is there a way to format the column headings of listboxes?

If not, I was thinking about putting labels above the listbox and formatting
them as I please, but that will only work if I know for sure the column
widths, etc. will be static.

Just wondering...

Thanks!
Joe
 
You cannot format the Column Headings so some are bold or italic etc.

You can change the name displayed in the heading without having to change
your field names or their captions. Just alias the fields in the RowSource,
e.g.:
SELECT Field1 AS [First Name To Show],
Field2 AS [Second Name To Show]
FROM MyTable;
 
Thank you for the info--aliasing the field names is a great idea!

Too bad you can't format the headings. I assume that also means that you
cannot format all of the column headings--is that correct? (e.g. give the
heading row a grey background)

Thanks again,
Joe


Allen Browne said:
You cannot format the Column Headings so some are bold or italic etc.

You can change the name displayed in the heading without having to change
your field names or their captions. Just alias the fields in the RowSource,
e.g.:
SELECT Field1 AS [First Name To Show],
Field2 AS [Second Name To Show]
FROM MyTable;

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

Joe Holzhauer said:
Is there a way to format the column headings of listboxes?

If not, I was thinking about putting labels above the listbox and
formatting
them as I please, but that will only work if I know for sure the column
widths, etc. will be static.

Just wondering...

Thanks!
Joe
Click to expand...
Click to expand...
 
Correct.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

Joe Holzhauer said:
Thank you for the info--aliasing the field names is a great idea!

Too bad you can't format the headings. I assume that also means that you
cannot format all of the column headings--is that correct? (e.g. give the
heading row a grey background)

Thanks again,
Joe


Allen Browne said:
You cannot format the Column Headings so some are bold or italic etc.

You can change the name displayed in the heading without having to change
your field names or their captions. Just alias the fields in the RowSource,
e.g.:
SELECT Field1 AS [First Name To Show],
Field2 AS [Second Name To Show]
FROM MyTable;


Joe Holzhauer said:
Is there a way to format the column headings of listboxes?

If not, I was thinking about putting labels above the listbox and
formatting
them as I please, but that will only work if I know for sure the column
widths, etc. will be static.
Click to expand...
Click to expand...
Click to expand...
 
Back
Top