[AccessD] combo box 101

Another approach is to build a string from for the first returned field:

Select FirstName & " " & Lastname as Fullname, PersonPK from tblPersons Order by  
FirstName, Lastname


But in the case you mention, set the first field to be the same width as the combox, but set 
the list width to be the sum of the lengths of the required strings.

-- 
Stuart

On 8 Aug 2011 at 22:10, William Benson (VBACreations. wrote:

> I appreciate the suggestion. 
> 
> A little late for now, but I will consider it heavily in future work.
> 
> Thanks Arthur.
> 
> I turned the item into a listbox instead.
> 
> I wanted to see all columns in the drop down list, and then only have
> one of them display.
> 
> I was too tired and punch drunk to just think to put the column I
> wanted displayed as the first column (Doh.)
> 
> Anyway, I went with a listbox instead.
> 
> 
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Arthur
> Fuller Sent: Monday, August 08, 2011 8:28 PM To: Access Developers
> discussion and problem solving Subject: Re: [AccessD] combo box 101
> 
> I don't want to get argumentative here; I hoping that the agreed
> purpose is discussion and exchange of information. But I have to say,
> I hate this kind of code, and every time I'm called in to do a job on
> some previous version, pretty much the second thing I do is search for
> any rowsources that begin with the word "SELECT", then open them and
> then save them to named queries I also hate the citation of a specific
> form and field on said form, because that renders the code strictly
> local, when in actuality you might to re-use that query in several
> places (other forms or subforms, other queries, various reports, etc.)
> 
> So my initial suggestion would be to replace the SELECT statement with
> a named query, and instead of using a reference to a specific form
> create some static functions that return the desired value(s) whether
> or not the form is open. That frees you up to set the static values
> and then run the queries from the immediate window, so you can debug
> them effectively.
> 
> The previous responses have also included good ideas about column
> width and column count.
> 
> HTH,
> Arthur
> 
> On Mon, Aug 8, 2011 at 5:42 PM, Bob Gajewski
> <rbgajewski at roadrunner.com>wrote:
> 
> > Sounds obvious, but check the column count ... Even if you have the
> > widths set for multiple columns (0",0",2") and the bound column set
> > (0), if your column count is set to 1 then that's all you get!
> >
> > Bob Gajewski
> >
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
> 
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>