Access 2000 Form

[§Chrissi§]

Hi All,

I used NWIND.mdb to try to build forms. I opened a form and put a listbox.
I put LastName for it. But when I
run it, it displays 1,2,3... 9. What is wrong?

Thank you.

 

[Dean]

Take a look at the ColumnCount and ColumnWidth properties, it is displaying
the 1st column which is probably the peopleID field. You probably want 2
columns, with a width of 0" for the 1st PeopleID field, and a width of 1"
for the lastName field.

 

[jleckrone]

Check the row source for your list box. It sounds like it's something
like "Select ID, Lastname From MyTable...." If that's the case, right
click your list box and select Properties. Click on the Format Tab.
Make sure the Column count says 2 and your column widths say 0";1".
That should give you what you are looking for.

 

[§Chrissi§]

Thank you both for help. It work now. Could you help me one more time?

I used NWIND.mdb (from MS, Northwind)to try to build forms. I opened a form
and put a textbox.
I put
[Employees]![LastName] & ", " & [Employees]![FirstName] for it. But when I
run it, it does not display the fullname. What is wrong?

Thank you.