Jump to content
Sign in to follow this  
Simon K

Current active record number

Recommended Posts

I have a "list" view - as I cursor/arrow up and down the list a different record is made active - is there a way of getting the "active" record number

- ie what i would like to do is a bit of conditional formatting on the list view that makes it slightly more obvious to the user which record they are on using a formula such as

if get (recordnumber of active/selected record) - ie the one with the cursor) equals get(recordnumber)

thanks

simon

ps any solution i use has to be 9 compatible but i am open to ideas...

Edited by Guest

Share this post


Link to post
Share on other sites

if get (recordnumber of active/selected record) - ie the one with the cursor) equals get(recordnumber)

1st Field) get(recordnumber) to populate a calculated field (stable)

2nd Field) a global field with auto-enter Get (RecordID) and "do not replace the value in the field (if any)" unchecked, so that it will dynamically change on selection.

When you select a record, the global field will match the calculated field and then you can do something with the result - set text or background color, set a radio button on the row to TRUE to indicate selection, use it in conditional formatting, whatever. Conditional formatting is not IWP compatible, nor are transparent buttons (see next paragraph), so a SELECT button on a layout row is my preferred method.

However, I am unsure that scrolling to a record itself is sufficient to trigger the change. I have always placed a transparent button on the layout row, so that when a user clicks on it, the change occurs.

Share this post


Link to post
Share on other sites

Take a look at the example files at Databasepros

Go to this Link

and do a search for Highlight Records.

Lee

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.