Display image at current record (A97)

Topic

New Reply

Would like to display an image at the current record of my continuous form subform. On the Form Load event is the following:
Forms!frmArchive!sfrmArchiveRecords![Image1].Visible = False.
In the On Current event of the subform is: Me![Image1].Visible = True. When initially opening the form there are no images displayed. When moving to another record, all records display an image. Is what I am trying to achieve possible?

Thanks
Ron

Reply | Quote

Replies

Do you have a specific reason for setting the Visible property to False in the On Load event? What happens if you omit that line from the On Load event?

Reply | Quote

If I remove the that line from the On Load event, when the form opens, all records have the image. The purpose of the image (a small arrow) is to act as a record selector or marker for the current record.

Reply | Quote

In a continuous form, a control is either visible in ALL records or invisible in ALL records. It is not possible to make it visible in just a single record. So you’ll have to think of something else – why not use the built-in record selector? It displays a triangle in the active record.

Reply | Quote

The built in record selectors will work just fine. Is there a way to prevent the user from doing a Ctrl A and then pressing the Delete key? That was what I was trying to avoid.

Thanks,
Ron

Reply | Quote

You’d have to create an event handler for the Before Delete Confirm or On Delete events, I think.

Reply | Quote

I will look into that. Thank you.

Ron

Reply | Quote

The attached demo shows how you can achieve the goal of your original post, but not by using an image. Instead there is a text box with conditional formatting which makes it appear whenever it is the current record.
I use something like this when I want something more obvious than the built-in record selectors.

Reply | Quote

Thank you for the information. That is what I was looking for. What keyboard combination creates the pointer figure? The other issue I my have is incorporating it into Access 97 because that version does not have conditional formatting.

Thank you
Ron

Reply | Quote

Sorry I did not notice that you were using 97. You are right that this will not work there, as conditional formatting is not available.
There was something similar, but even more convoluted, that worked in 97, but I would need to hunt it up. From memory, all it would do would be give a rectangular block of color.

To get the arrow, I inserted it into Word using Insert Symbol, then copied into Access.

Reply | Quote

See “Highlight a single row” on Liquorman, Inc.: Access Tips, Links, & Downloads, and also the attachment to post 227,142 for Access 97 methods.

Reply | Quote

Check out Mark Liquorman’s site, e has something similar that colours the whole of the pointed record.

Reply | Quote

Here is a version of what I posted before that works in 97. Using the idea that the Hans and Patt have pointed us to.

Reply | Quote

Thanks everyone for all the help. That is just what I was looking for.

Ron

Reply | Quote