MarkH
lists at theopg.com
Thu May 20 19:01:01 CDT 2004
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/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