Charlotte Foust
cfoust at infostatsystems.com
Thu May 20 18:00:50 CDT 2004
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