Jim Lawrence
accessd at shaw.ca
Tue Aug 22 13:44:43 CDT 2006
Thanks Andy and Robin... that simple! Jim -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Andy Lacey Sent: Tuesday, August 22, 2006 3:45 AM To: Access Developers discussion and problem solving Subject: Re: [AccessD] Filling a multi column combo box Jim Do you mean juts putting in a Value list? If so it's just a list of entried separated by semi-colons (or can be commas). The Number Of Columns property determines which fall in the same row and which in the next. So: Fred;Smith;Annie;Oakley with a Number Of columns of 1 will get you Fred Smith Annie Oakley but with Number Of Columns set to 2 will give you Fred Smith Annie Oakley Is that what you meant? HTH Andy Lacey http://www.minstersystems.co.uk --------- Original Message -------- From: "Access Developers discussion and problem solving" <accessd at databaseadvisors.com> To: "'Access Developers discussion and problem solving'" <accessd at databaseadvisors.com> Subject: [AccessD] Filling a multi column combo box Date: 22/08/06 08:40 Hi All: I have forgotten the simple method of filling a multi-columned combo box manually. I have been working with recordsets or simple single column recordsource lists for so long that manual syntax has been lost.... It could be as it is so late here. Any sharp minds out there? TIA Jim -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com ________________________________________________ Message sent using UebiMiau 2.7.2 -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com