[AccessD] combo box 101

Correct.   The only first *visible*  ( width > 0) column is displayed in a combobox's text area.


On 8 Aug 2011 at 10:37, Rusty Hammond wrote:

> 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
>