[AccessD] combo box 101

That would be my suggestion too, since the text part of a combo box
always displays the first non-zero width column.
Asger

----- Original meddelelse -----

> Fra: Rusty Hammond <rusty.hammond at cpiqpc.com>
> Til: Access Developers discussion and problem solving
> <accessd at databaseadvisors.com>
> Dato: Man, 08. aug 2011 17:37
> Emne: Re: [AccessD] combo box 101
> 
> Should your column widths then be 0";0";3" ?
> 
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of William
> Benson (VBACreations.Com)
> Sent: Monday, August 08, 2011 10:32 AM
> To: 'Access Developers discussion and problem solving'
> Subject: [AccessD] combo box 101
> 
> This ought to be a piece of cake. I have a combo with rowsource:
> 
> Select Source,
> Level1Basis as [Customer Level],
> ReportName
> from
> TblReportHeaders
> where
> Source = [forms]!frmMatchReport![cboBasis]
> and
> level1basis = [forms]!frmmatchreport![cbobasislevel1]
> 
> Columncount = 3.
> In terms of the display problem I am having, it doesn't seem to
> matter
> whether ColumnWidths is left blank, or I enter 0.5";1.5";3".
> What I want to show in the text portion of the combo is the 3rd
> field,
> [ReportName]
> 
> But what keeps being displayed after a selection, is the 1st column
> (Source)
> 
> Bound Column has been alternately set to 0, 1, or 2 ... it makes no
> difference.
> 
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
> **********************************************************************
> WARNING: All e-mail sent to and from this address will be received,
> scanned or otherwise recorded by the CPI Qualified Plan Consultants,
> Inc.
> corporate e-mail system and is subject to archival, monitoring or
> review
> by, and/or disclosure to, someone other than the recipient.
> **********************************************************************
> 
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com