Arthur Fuller
artful at rogers.com
Sun Jun 6 17:24:06 CDT 2004
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. -----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