Andy Lacey
andy at minstersystems.co.uk
Fri May 21 12:55:20 CDT 2004
Sorry Ken, if you feel I implied that anyone needed "forgiving" for anything. I just wanted to clarify why other solutions than Conditional Formatting had been proffered and discussed. Some people coming late to the discussion may have missed the point. -- Andy Lacey http://www.minstersystems.co.uk > -----Original Message----- > From: accessd-bounces at databaseadvisors.com > [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Ken Ismert > Sent: 21 May 2004 17:43 > To: 'Access Developers discussion and problem solving' > Subject: RE: > [AccessD]Highlightfieldbeingeditedinacontinuousform-in9simples > teps.-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-in9simples > teps.-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-in9simples > teps. -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/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 >