[AccessD] combo box 101

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 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Asger Blond
Sent: Monday, August 08, 2011 12:38 PM
To: Access Developers discussion and problem solving
Subject: Re: [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

--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com