[AccessD] Highlight field being edited in a continuous form.

Thanks Andy. I was looking at the GetLineNumber code and am developing exactly the same thing you are suggesting. I looked at that code and said "That's too much work. A couple lines of code should do." So far I'm at 1 line of code. 

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:	Wednesday, May 19, 2004 3:01 PM
To:	'Access Developers discussion and problem solving'
Subject:	RE: [AccessD] Highlight field being edited in a continuous form.

Scott
That is what I was looking for. I must have simplified it though (or used a
simplified version).

Firstly use OnCurrent to put the current record's unique id into an unbound
control in the form header, then the IIF test on the control in the detail
is just

=IIf(me!ctlInHeader=me!ctlInCurrentLine,"ÛÛÛÛÛÛÛÛÛÛÛÛ",Null) 

Which will only be true for one record. This causes that record to display
the solid bar and the rest Null.

The GetLineNumber function is far more complex than is necessary.

-- Andy Lacey
http://www.minstersystems.co.uk 


> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com 
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Doug Murphy
> Sent: 19 May 2004 19:35
> To: 'Access Developers discussion and problem solving'
> Subject: RE: [AccessD] Highlight field being edited in a 
> continuous form.
> 
> 
> Scott,
> 
> Take a look at http://www.mvps.org/access/forms/frm0047.htm. 
> Don't know if this is what your looking for but it gives a 
> way to highlight the record with focus in a continuous form.  
> I have used it and it works well.
> 
> Doug
> 
> Douglas Murphy
> Murphy's Creativity
> (619) 334-5121
> doug at murphyscreativity.com
> www.murphyscreativity.com
> 
> 
> 
> 
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of 
> Scott Marcus
> Sent: Wednesday, May 19, 2004 10:22 AM
> To: Access Developers discussion and problem solving
> Subject: [AccessD] Highlight field being edited in a continuous form.
> 
> 
> I've done this before for a textbox bound to a field that has 
> the color code in it. What I need is to change an UNBOUND 
> textbox to yellow in a continuous form when it has focus. The 
> problem I get is the textbox changes color for every instance 
> of that textbox in each record (not just the one being 
> edited). Any takers?
> 
> Scott Marcus
> TSS Technologies, Inc.
> marcus at tsstech.com
> (513) 772-7000
> 
> 
> 
> -- 
> _______________________________________________
> 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