Lookup item layout

[WillieLoMain]

I used the lookup wiz in Table2 to grab data from table1.

I have this setup so that when you click on the combo box there are 3 columns of info that can be seen.

During the run of the wizard I can format the width of these 3 columns so that I can see all the data while in the datasheet view and have clicked on the selection arrow.

Once in the datasheet view - the columns are at times too wide or not wide enuff.

My question is - how do I format the width of these colums so that I can see all that I need to WITHOUT running the wizzard again.

Despite several attempts, I see no place to do this.

Thanx much in advance.

 

[MichaelintheUK]

Hello Willie

In table design select the field and then go to the lookup properties below and set something similar to the following

ColumnCount: 3
Column width 1;2;2.5
Listwidth: 5.5

Hope this helps

Michael

 

[WillieLoMain]

TY much - that was the answer - and I feel foolish as usual for not looking in the right place.