List box does not show street address?

[fjcunninghamjr]

Hi, I created a query to show first name, last name and street address. Query works and shows all the info. When I create a list box on a new form using the results from the query, only first name and last name appear not the address. What am I missing?


any help is greatly appreciated!
Frank

[moke123]

Do you have the column counts and widths set correctly?

[fjcunninghamjr]

Thanks good suggestion, I did increase the col width and checked number of col but still address doesn’t show, in the process I noticed the col title for ‘address, is not there neither.

[Welshgasman]

Show a picture of your properties for column count etc. You need to attach any pics, using the Advanced button, then Manage attachments, not copy and paste into the post.
Show the sql for the listbox source.

[fjcunninghamjr]

WelshGasMan,
Thanks for taking an out at this:

[CJ_London]

in the process I noticed the col title for ‘address, is not there neither.

according to your first post, your query has 3 columns ( first name, last name and street address) so your column count value should be 3. Implication is you have set it to 2.

and when you checked column widths - did you also check the width of the listbox is large enough for all 3 columns to appear.

Edit - see you have now done that - please also show a screenshot of the form to display the values and also one of the property data tab - to confirm the rowsource is 'searchquery'

[Micron]

Is that names, addresses and social security numbers for real people?? If it is, better get an admin to remove that pic ASAP.

[Welshgasman]

according to your first post, your query has 3 columns ( first name, last name and street address) so your column count value should be 3. Implication is you have set it to 2.

and when you checked column widths - did you also check the width of the listbox is large enough for all 3 columns to appear

When it actually has 4 , but they do appear to be accounted for. Plus the width should be enough to show the 4th column, well the first few inches at least?
Any particular reason why the properties pic was on it's side and not in the normal position?
Can we have a pic of the listbox?

[CJ_London]

Any particular reason why the properties pic was on it's side and not in the normal position?

looks like a photo to me

[moke123]

The photo with names should be removed ASAP.

Names and addresses are legit but SS#'s are not. (I have some resources)

OP may have to change the table name to tblFormerClients.

[fjcunninghamjr]

there are four columns, the first column is not visible, 2nd col is First Name, 3 col is Last Name and the 4th col is Address.

[Welshgasman]

Upload a sample DB and we can see what any others get then.?

[Welshgasman]

The photo with names should be removed ASAP.

Names and addresses are legit but SS#'s are not. (I have some resources)

OP may have to change the table name to tblFormerClients.

Even as a UK citizen, I thought the SSNs did not look kosher.

[moke123]

Upload a sample DB and we can see what any others get then.?

before you do, try using the randomizer app found here . . https://www.access-programmers.co.uk.../#post-1640309

Use a copy of your database!

[pbaldy]

I removed the picture with actual names and addresses. I'd follow Moke's advice if you post a sample db.