[AccessD] combo box Limit to List question

Can you set the first column width to .001", and get around it that way?

Rocky Smolin
Beach Access Software
http://www.e-z-mrp.com


----- Original Message ----- 
From: "Stuart McLachlan" <stuart at lexacorp.com.pg>
To: "Access Developers discussion and problem solving"
<accessd at databaseadvisors.com>
Sent: Sunday, June 06, 2004 3:41 PM
Subject: RE: [AccessD] combo box Limit to List question


> On 6 Jun 2004 at 18:24, Arthur Fuller wrote:
>
> > This is clearly incorrect. I'm not sure what you're doing wrong but as
> > long as the bound column is the first column, set its width to zero and
> > no problems. I have done this hundreds of times.
> >
> You must have a different MS Access to me then :-)
>
>  Whenever I do that, the LimitToList is set automagically to Yes. When I
try to
> change it back to No, I get a very clearly explained error message:
>
> "Microsoft Access can't set the LimitToList property to No right now.
> The first visible column which is determined by the ColumnWidths property,
> isn't equal to the bound column.
> Adjust the ColumnWidths property first, then set the LimitToList property"
>
> AFAIR, it's been the same for every version of Access over the last 10
years up
> to and including A2K
>
>
> > -----Original Message-----
> > From: accessd-bounces at databaseadvisors.com
> > [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Susan Harkins
> > Sent: Sunday, June 06, 2004 12:11 PM
> > To: 'Access Developers discussion and problem solving'
> > Subject: RE: [AccessD] combo box Limit to List question
> >
> >
> > Here's what I've found with just a little testing:
> >
> > Access automatically updates the Limit To List setting from No, the
> > default, to Yes if the bound column isn't the first column or if the
> > bound column is the first column, but you render it invisible. Not only
> > must the bound column be visible to the user, it must be the first
> > column in the control.
> >
> > Now, I might not have it exactly right as there may be more or less to
> > it all. But so far, that seems the gist of it. Now, when you consider
> > all that's going on, I can understand the limitation -- but it seems
> > like one that they'd have allowed for in some way.
> >
> > Susan H.
> >
> >
> > Susan:
> >
> > I'm just about to have this problem.  Combo box with a PK of AssetID in
> > the invisible column(0) and the asset bar code in column(1) - visible.
> > List is limited to assets of a certain type but if the user enter a bar
> > code of a different type then I have to process it anyway.  Bound column
> > is AssetID.
> >
> > I'll be following this thread and I'll let you know if I find a way
> > around it.
> >
> > Rocky Smolin
> > Beach Access Software
> > http://www.e-z-mrp.com
> >
> >
> > ----- Original Message -----
> > From: "Susan Harkins" <ssharkins at bellsouth.net>
> > To: "'Access Developers discussion and problem solving'"
> > <accessd at databaseadvisors.com>
> > Sent: Sunday, June 06, 2004 7:43 AM
> > Subject: [AccessD] combo box Limit to List question
> >
> >
> > > Here's one I've never run across before -- you can't set the Limit to
> > > LIst property to No if the control's bound column isn't visible?
> > > Wow... that's
> > a
> > > nasty little catch that could really be a clean up mess if you weren't
> >
> > > prepared for it. I've never run into it before. So, if you want an
> > > updateable list, you have to display the bound column instead of
> > > whatever data you really want to display... nasty. :(
> > >
> > > Susan H.
> > > --
> > > _______________________________________________
> > > 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
> >
> > -- 
> > _______________________________________________
> > 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
>
>
> -- 
> Lexacorp Ltd
> http://www.lexacorp.com.pg
> Information Technology Consultancy, Software Development,System Support.
>
>
>
> -- 
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com