List Box Headings

[mateogp]

Hello,

I was hoping one of you experts could help me out with a small problem I am having.

I use a listbox to sort data from a table. Only problem is that the heading for each row uses the name of that column. For example, one row may be titled "LN". I would want that row to be headed "Last Name". I got it to work on the first 3 columns, but after that column is goes back to listing it as the name of that row on the table.

The way that worked on the first three colums is by using query builder, and under field I used "Last Name: LN". It worked, like i said, onthe first 3 colums. The Last four unfortunatly didnt. Not quite sure why it wouldnt.. im stumped. Any Ideas?

Second Problem
The table wont show the first column. What I have to do to solvet his problem is fill the first row in with data, and then repeat it a second time to show the correct data.


Thanks in advance for any help you may be able to provide!


Matt

 

[Newman]

To change the headings in the list, you have to add the label you want in the «Legend» property of that field in the table.

To show all the fields in the list, make sure that the «Number of columns» and «Columns width» properties of that list are set corectly.

Note that these property names are rude translations from Office french edition. It might be different in your vesion, but you should be able to find which is which easily.