Bolding column headings - Microsoft Access Forum


	Back to Access Forum Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

Bolding column headings

Jerry Fowler

16 months ago

I am populating a list box on a form that I have been using code similar to the following;

'Populate Categories on the list box
    Me.MainListBox.RowSource = "SELECT CategoryID, UserID, CategoryName, CreatedAt, UpdatedAt, Status, StatusDate FROM CategoryT"
    Me.MainListBox.ColumnHeads = True
    Me.MainListBox.ColumnCount = 7
    Me.MainListBox.ColumnWidths = "0cm;0cm;5cm;2cm;2cm;3cm;2cm;"

What I have been trying to do but have yet to find a way to do is to bold the column headings since I am using the .ColumnHeads = True

	Jennifer Neighbors @Reply 16 months ago
I have found the best way to create nice column headings is to set .ColumnHeads = False and position one or two labels where I'd want the column heads, using Bold, Italic, or Font Colors to style the heading.

	Kevin Robertson @Reply 16 months ago
You don't have any control over the formatting of the Column Headers. Like Jennifer said use label instead. You will have full control over formatting and can add code to them if needed.

	Jerry Fowler OP @Reply 16 months ago
I was kind of already figuring that there was no control over it. Thanks for the ideas on what to do and I've started the label headings and that will work just fine.

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Forum.

Next Unseen

New Feature: Comment Live View