[AccessD] combo box Limit to List question

Stuart McLachlan stuart at lexacorp.com.pg
Sun Jun 6 17:41:28 CDT 2004


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.






More information about the AccessD mailing list