Combo Box Problem

[AccessNewb11]

Hi all! I have a question.

I have a database with a form I am working on. On the form I put a combo box that I can use to choose a Law Enforcement agency, then the law enforcement agencies' information would auto populate (address, city, zip, etc.).

Well, this morning I opened up my database that I am working on and made some changes to my form, tested everything out, and was happy with the results. Then I moved fields around (layout changes) and added some fields from another table. Then, when I went in to test my first combo box that I talked about in the first paragraph above, it has all of the information in the combo list selection so that now it just looks ugly when selecting it. Whereas before, it showed JUST the agency name, and it auto populated the rest into the fields. You can see what I mean in the screen shot below in the attachment.



Why is it doing this all of a sudden? Literally, it was working half an hour ago with JUST the agency name. Now, it shows everything in there and I didn't even change anything!!!

Thanks in advance!

~Access Newb~

[ItsMe]

Can you post your combobox RowSource here? if the RowSource is based on a query, can you post the SQL for the query here?

[AccessNewb11]

Yes! Row source:

SELECT [AgencyInfo].[AgencyName], [AgencyInfo].[County], [AgencyInfo].[Address], [AgencyInfo].[City], [AgencyInfo].[State], [AgencyInfo].[ZipCode] FROM AgencyInfo ORDER BY [AgencyName];

Thanks.

[June7]

Looks like the ColumnWidths property was changed.

[ItsMe]

Like June7 mentioned, the Column Widths property was somehow adjusted.

Because you have this in your RowSource
SELECT [AgencyInfo].[AgencyName]

You can display AgencyName with a Column Widths property of
1.5"

Because you have this in your RowSource
SELECT [AgencyInfo].[AgencyName], [AgencyInfo].[County], [AgencyInfo].[Address]

You can hide AgencyName and display County with a Column Widths property of
0";2"

Determine how many columns you want to hold in your combo's memory and place that number in the Column Count property
Column Count: 3

Then choose which columns you want displayed and which you want hidden
Column Widths: 1.1";0";2"

[AccessNewb11]

Great, thanks guys, I really appreciate it! I got it looking nice now.