MarkH
lists at theopg.com
Thu May 20 19:05:39 CDT 2004
Just tried it and it seems to work ok (using XP). I only did a simple test though, I may give it a go with something more complex tomorrow... I'm off to get some sleep... Night night Mark -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Charlotte Foust Sent: 21 May 2004 00:51 To: Access Developers discussion and problem solving Subject: RE: [AccessD]Highlightfieldbeingeditedinacontinuousform-in9simplesteps. -maybe too simple? I've never been very happy with it, so I tend to fall back on other methods. It may work better in XP and 2003, but I haven't bothered to try it. Charlotte Foust -----Original Message----- From: MarkH [mailto:lists at theopg.com] Sent: Thursday, May 20, 2004 3:36 PM To: 'Access Developers discussion and problem solving' Subject: RE: [AccessD] Highlightfieldbeingeditedinacontinuousform-in9simplesteps. - maybe too simple? Hehehe, nice one... Just realised how blinkered I am, despite sitting in front of Access every day developing screens etc. I hadn't noticed the conditional formatting option (maybe coz I never needed it, maybe coz I'm getting on a bit). I must have looked straight at it thousands of times... I need a holiday. Cheers Mark -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Ken Ismert Sent: 21 May 2004 00:23 To: 'Access Developers discussion and problem solving' Subject: RE: [AccessD] Highlight fieldbeingeditedinacontinuousform-in9simplesteps. - maybe too simple? I love it!!! Simple, no code, works in A2K. Great color flexibility. Another method for highlighting the current field in A2K and later: Select your form controls. Select Format, Conditional Formatting... in the Condition 1 dropdown, select Field Has Focus, then set your background and font style. This method works in datasheet style forms, too. Sadly, checkboxes can't have conditional formatting. -Ken -----Original Message----- From: MarkH [mailto:lists at theopg.com] Sent: Thursday, May 20, 2004 5:32 PM To: 'Access Developers discussion and problem solving' Subject: RE: [AccessD] Highlight field beingeditedinacontinuousform-in9simplesteps. - maybe too simple? No worries :@) That's what I thought initially. I did a simple form and tried it out. Only the field in the current row that has the focus changes colour. I don't recall if this is how previous versions of Access behaved, but I do remember several years ago coming across the same problem and, if I remember correctly, a similar solution to the one mentioned earlier (the 9 steps bit). Only the control with the focus changes colour, not all of the ones in the same row or column... Mark PS - my memories clearing a bit... The problem I came across before was how to make alternate rows in a continuous form different colours. The solution looked similar, no idea where I saw it though. -- _______________________________________________ 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