[AccessD]Highlightfieldbeingeditedinacontinuousform-in9simplesteps.-maybetoo simple?

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
> 




More information about the AccessD mailing list