Scott Marcus
marcus at tsstech.com
Mon May 24 08:19:20 CDT 2004
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 -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Ken Ismert Sent: Friday, May 21, 2004 12:43 PM To: 'Access Developers discussion and problem solving' Subject: RE: [AccessD]Highlightfieldbeingeditedinacontinuousform-in9simplesteps.-maybetoo simple? The thread is titled "Highlight field being edited in a continuous form - in 9 simple steps", so I think we can be forgiven for addressing that issue. Mark's solution works in A97, using 0 coding steps. The real question is why field highlighting, combined with the record selector, is not adequate. Yes, it doesn't highlight check boxes, which is a pity. Yes, you can code around it, but are the gains really worth the cost? We all enjoy the challenge of solving these problems, but maybe in this case it is better to say the no-code solution is good enough. I would prefer the simple but compromised solution over a 'better' one that adds to the code base I have to maintain. -Ken -----Original Message----- From: Scott Marcus [mailto:marcus at tsstech.com] Sent: Friday, May 21, 2004 6:10 AM To: Access Developers discussion and problem solving Subject: RE: [AccessD]Highlightfieldbeingeditedinacontinuousform-in9simplesteps.-mayb e too simple? Andy, You are correct. My original question was centered around Acc97(mentioned in my second follow-up e-mail) and checkboxes. 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 Andy Lacey Sent: Friday, May 21, 2004 2:42 AM To: 'Access Developers discussion and problem solving' Subject: RE: [AccessD]Highlightfieldbeingeditedinacontinuousform-in9simplesteps. -maybe too simple? If my memory seves me right this thread started on an A97 problem. No conmditional formatting in A97. That's why we have to go all around the houses to achieve this. -- Andy Lacey http://www.minstersystems.co.uk > -----Original Message----- > From: accessd-bounces at databaseadvisors.com > [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of MarkH > Sent: 21 May 2004 01:01 > To: 'Access Developers discussion and problem solving' > Subject: RE: [AccessD] > Highlightfieldbeingeditedinacontinuousform-in9simplesteps. - > maybe too simple? > > > Cool... Just tried the conditional formatting, you can get > the highlighted row effect by: > > a) add a hidden unbound field to the form header (or detail?) > b) in the got focus event (of the detail fields) set > the unbound field > to the records key fields value > c) in the conditional formatting put something like > Expression is: [c1]=[c3] > where [C1] is the key and [c3] the hidden control > in the header (or detail?) > d) copy the formatting to the other fields in the row > > Dunno if this is efficient but its pretty easy... Got a new toy :O) > > 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:01 > To: Access Developers discussion and problem solving > Subject: RE: [AccessD] Highlight > fieldbeingeditedinacontinuousform-in9simplesteps. - maybe too simple? > > > Only the current record can get the focus. If you have a > combobox in a continuous form, all instances don't drop down > when you click the arrow in the current record. Using the > Backcolor and backstyle method works the same way. I didn't > suggest this one because I understood the original question > to ask how to highlight the whole current record, not just > the control with the focus. This method goes back at least > to 97, since I used it there. > > Charlotte Foust > > -----Original Message----- > From: MarkH [mailto:lists at theopg.com] > Sent: Thursday, May 20, 2004 2: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. > > > -----Original Message----- > From: accessd-bounces at databaseadvisors.com > [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Andy Lacey > Sent: 20 May 2004 22:36 > To: 'Access Developers discussion and problem solving' > Subject: RE: [AccessD] Highlight field being > editedinacontinuousform-in9simplesteps. - maybe too simple? > > > Sorry Mark. Surely on a continuous form all records are > affected, whereas the requirement was to highlight only the > current row. If this does that I'll stand corrected and don't see how. > > Andy > > > -----Original Message----- > > From: accessd-bounces at databaseadvisors.com > > [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of MarkH > > Sent: 20 May 2004 21:45 > > To: 'Access Developers discussion and problem solving' > > Subject: RE: [AccessD] Highlight field being > > editedinacontinuousform-in9simple steps. - maybe too simple? > > > > > > Hi Andy > > > > It works on continuous forms too... Just tried it > > > > Mark > > > > -----Original Message----- > > From: accessd-bounces at databaseadvisors.com > > [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of > Andy Lacey > > Sent: 20 May 2004 21:41 > > To: 'Access Developers discussion and problem solving' > > Subject: RE: [AccessD] Highlight field being edited > > inacontinuousform-in9simple steps. - maybe too simple? > > > > > > Mark > > It was the continuous forms bit you missed. > > > > -- Andy Lacey > > http://www.minstersystems.co.uk > > > > > -----Original Message----- > > > From: accessd-bounces at databaseadvisors.com > > > [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of MarkH > > > Sent: 20 May 2004 21:27 > > > To: 'Access Developers discussion and problem solving' > > > Subject: RE: [AccessD] Highlight field being edited in > > > acontinuousform-in9simple steps. - maybe too simple? > > > > > > > > > Hello > > > > > > I've missed most of this thread so apologies if this is a time > > > waster... > > > > > > If all you want to do is highlight a text box that has the > > focus then > > > just set the back colour to the highlight colour and make > the back > > > style transparent. As long as the forms background is a different > > > colour Access does the rest. No code :O) > > > > > > Sorry if this isn't relevant > > > > > > Mark > > > > > > -- > > > _______________________________________________ > > > AccessD mailing list > > > AccessD at databaseadvisors.com > > > http://databaseadvisors.com/mailman/listinfo/a> ccessd > > > Website: > > > http://www.databaseadvisors.com > > > > > > > > > > -- > > _______________________________________________ > > AccessD mailing list > > AccessD at databaseadvisors.com > > http://databaseadvisors.com/mailman/listinfo/a> ccessd > > Website: > > http://www.databaseadvisors.com > > > > -- > > > > _______________________________________________ > > AccessD mailing list > > AccessD at databaseadvisors.com > > http://databaseadvisors.com/mailman/listinfo/a> ccessd > > Website: > > http://www.databaseadvisors.com > > > > > > -- > _______________________________________________ > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/a> ccessd > Website: > http://www.databaseadvisors.com > > -- > > _______________________________________________ > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/a> ccessd > Website: > http://www.databaseadvisors.com > -- > > _______________________________________________ > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/a> ccessd > Website: > http://www.databaseadvisors.com > > -- > > _______________________________________________ > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/a> ccessd > 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