[AccessD]Highlightfieldbeingeditedinacontinuousform-in9simplesteps. -maybe too simple?

Scott Marcus marcus at tsstech.com
Fri May 21 06:10:13 CDT 2004


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







More information about the AccessD mailing list