I'm not sure where to post this question so I thought I would start here.

I have a columnar type layout that displays a list of work orders for my cabinet shop. The problem we are having is that it is not so obvious which record is the active one.

Is there a way of colorcoding the active field or record so that it jumps out at you on the screen?

Thanks for any insight!

Jarvis

If there is I would like to know about it. I've run into this a couple of times and have not yet found a solution. The bottomline is that there is no way to determine that the "current" record is the "active" record.

A work-around I've used is to make a field (or the entire row) into a button that performs a script. This script sets a global (gRecordID) to the current Record ID. A calculation field then marks the record, for example by the following

If (Get(RecordID)=gRecordID;">";"")

Of course, you can use whatever you want for marking the record, like a graphic. See the attachment for a working example.

Unfortunately this doesn't work if somebody navigates using anything else than the above mechanism, for example using the rolodex/book or keyboard shortcuts.

So if anybody has any better ideas, let's hear 'em.

Regards,

Peter

Mark.zip

Peter,

This looks like it will do what I want.

Thanks for your help!

Jarvis

See here for a technique that does not require a calculation.

Thanks for the tip, Queue.

Those Nightwing guys sure have some cool stuff.

jarvis