Darren D
darren at activebilling.com.au
Mon Sep 8 18:15:32 CDT 2008
Hi Dan Yes sadly I realised - "this ain't gonna work" So I bound a text box to the AppName field - made it transparent and put it over a button with no caption. I then set the 'is hyperlink' property to yes to get the 'pointing finger' mouse icon when the mouse went over it That'll have to do Many thanks for your reply Darren -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Dan Waters Sent: Tuesday, 9 September 2008 12:46 AM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] A2003: Table Driven button list on Continuous Forms Hi Darren, I use buttons on continuous forms quite a bit. To my knowledge, you cannot do what you're trying to do. The only way to change the appearance of a control is to use Conditional Formatting, and button up/button down appearance is not part of conditional formatting. Perhaps you could use a textbox instead of a label for your button, and slightly change color to substitute for button up/button down using Conditional Formatting. Conditional Formatting only works with textboxes and comboboxes. Can you use a regular button on each record that says 'Open App'. The user knows which app since its name is displayed. Or, could you set up a double-click event in the app name control to open the app? No button at all. Just some thoughts, Dan -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Darren D Sent: Monday, September 08, 2008 7:25 AM To: 'Access Developers discussion and problem solving' Subject: [AccessD] A2003: Table Driven button list on Continuous Forms Hi All I have a table of application names that will grow and shrink with many fields but the 2 of interest are. APPID = AutoNumber and AppName = Text I want a continuous form to have a button for each item in that table. Trouble is It is a bit tricky to get the caption for each button to = the AppName for each record in the table I can 'fake' it using labels but if I write a routine to simulate a mouse down and mouse up to mimic raises and depressions then all the labels that are simulated buttons on the form depress and raise at the same time Besides I would prefer to have the 'rounded' look to the buttons simply to match the rest of my screen design I know many people have done this sort of thing before - But how have you managed it on a continuous form driven by a table Many thanks in advance Darren -- 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