Scott Marcus
marcus at tsstech.com
Mon May 24 13:42:43 CDT 2004
Mark, It changes the color of the controls to that of the background. This introduces more work to get them to look like they normally appear when not set to transparent. So for me to say that it doesn't work, isn't entirely true. It just doesn't work the way I want it to work. Scott Marcus TSS Technologies, Inc. marcus at tsstech.com (513) 772-7000 -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of MarkH Sent: Monday, May 24, 2004 2:37 PM To: 'Access Developers discussion and problem solving' Subject: RE: [AccessD]Highlightfieldbeingeditedinacontinuousform-hmmmmm worksfor me matey Scott... I just tried the first solution I offered in Access 97 and it works just fine. Just set a background colour (different to the forms background colour), then make the back style transparent and make sure the subform is set to continuos not datasheet. As mentioned by Charlotte, this only provides field highlighting not row highlighting, as can be achieved with conditional formatting in XP etc. Whichever field has the focus has its background made visible by access until it loses the focus... Second point... Sorry I missed the start of the thread, I'm not even sure who started it, good luck whoever you are :@) didn't mean to spark anything off, was just having a bit of fun as I was bored... It can be very frustrating having your hands tied by the limitations of a clients setup. I'm sure you will be making the most of whats available, particularly through subscribing to this very informative list. All the best Mark -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Scott Marcus Sent: 24 May 2004 14:19 To: Access Developers discussion and problem solving Subject: RE: [AccessD]Highlightfieldbeingeditedinacontinuousform-in9simplesteps.-mayb etoosimple? Ken, Highlighting individual fields on a continuous form in Acc97 requires coding when the continuous form is a sub form. The solution Mark gave doesn't work for Acc97. I'm sorry that you aren't interested in the solution for check boxes. The "...- in 9 simple steps " is a continuation of an earlier post. As a courtesy to those who helped me, I provide the solution steps I took. These steps are then kept in the archive so that others may search for the solution later (including myself). I hate to be crass(and wouldn't normally reply to your comments), but look at the context of a solution before you knock it. I'm just trying to provide a polished interface for my end user given the constraints of the hardware and software on their machine. Scott Marcus -- _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com