[AccessD] combo box Limit to List question

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




More information about the AccessD mailing list