Mark H
Lists at theopg.com
Tue Jul 22 05:42:03 CDT 2003
Ooooops - meant to send this to the Excel list. Sorry guys... Mark PS - doesn't forms in Excel suck compared to Access. I'd kill for the same functionality right now :O) -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Mark H Sent: 22 July 2003 11:33 To: 'Access Developers discussion and problem solving' Subject: [AccessD] One scrollbar controlling two list boxes - or just sync the two(may be difficult) Hello All... Using Excel XP I have an expenses form which displays two list boxes side by side. They act as one in that I split it in two so that text could be justified left (in the first) and numbers right (in the second). Wrote a little code to match the selected item on one to the other in the on_click event and thought "yippeee! That was easy..." Then I realised if there are more records than can be displayed I would have to synchronise the scrolling as well... Doh! I was hoping to switch off the scrollbars in the two listboxes and replace them with an independent one that could control both... Can't switch 'em off though :O( Any ideas much appreciated Cheers Mark _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com